473,387 Members | 1,569 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Compilier will not recognize DataSet object.

Compilier will not recognize DataSet object.

As you can see below is from a test simple form with no
other code. I'm just trying to get any Aspx form to
recognize the DataSet object. You can see from the code
I am importing System.Data.SqlClient. I can get to
DataReader, DataView and DataTable but Visual Studio
won't even bring up DataSet on Intellisense, much less
compile it. The message I get is: "Reference required
to assembly 'System.Xml' containing the implemented
interface 'System.Xml.Serialization.IXmlSerializable'.
Add one to your project.

But I don't want that one. I want the one in
System.Data.SqlClient. Same thing happens when I try
System.Data.oleDB. What painfully obvious step am I
missing here?

Thanks,

Dave
Imports System.Data
Imports System.Data.SqlClient

Public Class WebForm1
Inherits System.Web.UI.Page
Protected WithEvents DataSet1 As System.Data.DataSet
Private Sub Page_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load

'Put user code to initialize the page here
Dim obj As dataset = New dataset()

End Sub

End Class
Nov 17 '05 #1
9 2249
Hi,

DataSet is a class that enables you to store data on your application
memory and manipulate it. DataSet is made from DataTables and Relations
between them. to Fill DataTable one can use DataAdapter of SQLClient,
OLEDB, OracleClient or any other DB connectivity namespace.

As you see DataSet is not part of any DB namespace it is "global" class
that enable you to store data and you can decide what is the source of
that Table.

The DataSet can be handling as XML file. Actually it got XSD file
(schema) that set the Tables, fields, relations and other Meta data.
That is the reason way DataSet need reference to System.XML.

Natty Gur, CTO
Dao2Com Ltd.
28th Baruch Hirsch st. Bnei-Brak
Israel , 51114

Phone Numbers:
Office: +972-(0)3-5786668
Fax: +972-(0)3-5703475
Mobile: +972-(0)58-888377

Know the overall picture
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 17 '05 #2

I have the VB.NET equivelent.

Imports System.Data
Imports System.Data.SqlClient
(rest of the code is at the bottom of the page.)

And that is what baffles me. I can get to the other
objects exposed from the namespace such as DataReader,
DataView and DataTable. It is _just_ DataSet that will
not get recognized.

Dave

-----Original Message-----

do you have "using System.Data;" in your code and have a
reference to System.Data.dll?

-----Original Message-----
Compilier will not recognize DataSet object.

As you can see below is from a test simple form with no
other code. I'm just trying to get any Aspx form to
recognize the DataSet object. You can see from the codeI am importing System.Data.SqlClient. I can get to
DataReader, DataView and DataTable but Visual Studio
won't even bring up DataSet on Intellisense, much less
compile it. The message I get is: "Reference required
to assembly 'System.Xml' containing the implemented
interface 'System.Xml.Serialization.IXmlSerializable'.
Add one to your project.

But I don't want that one. I want the one in
System.Data.SqlClient. Same thing happens when I try
System.Data.oleDB. What painfully obvious step am I
missing here?

Thanks,

Dave
Imports System.Data
Imports System.Data.SqlClient

Public Class WebForm1
Inherits System.Web.UI.Page
Protected WithEvents DataSet1 As System.Data.DataSet
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs) Handles MyBase.Load

'Put user code to initialize the page here
Dim obj As dataset = New dataset()

End Sub

End Class
.

.

Nov 17 '05 #3
That is indeed odd. What error message do you get when you add the
reference?

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:09****************************@phx.gbl...
"So, why don't you just add the reference that

the compiler told you to add?"

Actually, I tried that. Adding 'Imports System.Xml'
doesn't help.

You're right though, System.Data.SqlClient doesn't have
anything to do with the DataSet object. That does just
confuse the issue. However, I am already importing
System.Data and that is the source of my confusion. Why
am I (apparently) getting all the other objects and
methods available to me from the System.Data namespace
except for DataSet?

Thanks,

Dave

-----Original Message-----
System.Data.SqlClient has nothing to do with DataSets. A

DataSet is not
provider-specific, so it resides in the System.Data

NameSpace. Adding a
reference to the Assembly does nothing but make it

available to your app.
Case in point, adding a reference to

System.Data.SqlClient, which as I
mentioned, is not necessary. So, why don't you just add

the reference that
the compiler told you to add?

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:09****************************@phx.gbl...

I think I understand what you're trying to say. But
DataSet, according to all documention I've come across
(Microsoft, Wrox Books, etc.), says DataSet is part of
the System.Data namespace. I've also imported
System.Data.SqlClient. Both the compilier and
Intellisense pick up on other related objects such as
DataReader, DataView, DataTable and a host of others.
Why not DataSet?

Dave

>-----Original Message-----
>Hi,
>
>DataSet is a class that enables you to store data on
your application
>memory and manipulate it. DataSet is made from
DataTables and Relations
>between them. to Fill DataTable one can use DataAdapter
of SQLClient,
>OLEDB, OracleClient or any other DB connectivity
namespace.
>
>As you see DataSet is not part of any DB namespace it
is "global" class
>that enable you to store data and you can decide what is the source of
>that Table.
>
>The DataSet can be handling as XML file. Actually it got XSD file
>(schema) that set the Tables, fields, relations and
other Meta data.
>That is the reason way DataSet need reference to
System.XML.
>
>Natty Gur, CTO
>Dao2Com Ltd.
>28th Baruch Hirsch st. Bnei-Brak
>Israel , 51114
>
>Phone Numbers:
>Office: +972-(0)3-5786668
>Fax: +972-(0)3-5703475
>Mobile: +972-(0)58-888377
>
>Know the overall picture
>
>
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>

.

Nov 17 '05 #4
The message I get is: "Reference required
to assembly 'System.Xml' containing the implemented
interface 'System.Xml.Serialization.IXmlSerializable'.
Add one to your project." (I removed the path name part of
the message.)

I get this message with or without adding System.Xml.
Under all circumstances I have System.Data. Also, to
clarify, I get the error when building the project as well
as VS.NET has it underlined as an error with the same
message.

Thanks for you help. I'm just dumbfounded since I have
access to the other objects in the namespace. Yeah, I
even tried the 'ol reboot windows trick. I'm running XP
Professional.

Dave

-----Original Message-----
That is indeed odd. What error message do you get when you add thereference?

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:09****************************@phx.gbl...
>"So, why don't you just add the reference that

the compiler told you to add?"

Actually, I tried that. Adding 'Imports System.Xml'
doesn't help.

You're right though, System.Data.SqlClient doesn't have
anything to do with the DataSet object. That does just
confuse the issue. However, I am already importing
System.Data and that is the source of my confusion. Why
am I (apparently) getting all the other objects and
methods available to me from the System.Data namespace
except for DataSet?

Thanks,

Dave

>-----Original Message-----
>System.Data.SqlClient has nothing to do with DataSets. A
DataSet is not
>provider-specific, so it resides in the System.Data

NameSpace. Adding a
>reference to the Assembly does nothing but make it

available to your app.
>Case in point, adding a reference to

System.Data.SqlClient, which as I
>mentioned, is not necessary. So, why don't you just add

the reference that
>the compiler told you to add?
>
>HTH,
>
>Kevin Spencer
>Microsoft FrontPage MVP
>Internet Developer
>http://www.takempis.com
>Big things are made up of
>lots of Little things.
>
>"Dave" <mi*******@hudnutt.com> wrote in message
>news:09****************************@phx.gbl...
>>
>> I think I understand what you're trying to say. But
>> DataSet, according to all documention I've come
across >> (Microsoft, Wrox Books, etc.), says DataSet is part of >> the System.Data namespace. I've also imported
>> System.Data.SqlClient. Both the compilier and
>> Intellisense pick up on other related objects such as
>> DataReader, DataView, DataTable and a host of others.
>> Why not DataSet?
>>
>> Dave
>>
>> >-----Original Message-----
>> >Hi,
>> >
>> >DataSet is a class that enables you to store data on
>> your application
>> >memory and manipulate it. DataSet is made from
>> DataTables and Relations
>> >between them. to Fill DataTable one can use DataAdapter >> of SQLClient,
>> >OLEDB, OracleClient or any other DB connectivity
>> namespace.
>> >
>> >As you see DataSet is not part of any DB namespace it >> is "global" class
>> >that enable you to store data and you can decide what is
>> the source of
>> >that Table.
>> >
>> >The DataSet can be handling as XML file. Actually it

got
>> XSD file
>> >(schema) that set the Tables, fields, relations and
>> other Meta data.
>> >That is the reason way DataSet need reference to
>> System.XML.
>> >
>> >Natty Gur, CTO
>> >Dao2Com Ltd.
>> >28th Baruch Hirsch st. Bnei-Brak
>> >Israel , 51114
>> >
>> >Phone Numbers:
>> >Office: +972-(0)3-5786668
>> >Fax: +972-(0)3-5703475
>> >Mobile: +972-(0)58-888377
>> >
>> >Know the overall picture
>> >
>> >
>> >*** Sent via Developersdex

http://www.developersdex.com >> ***
>> >Don't just participate in USENET...get rewarded for it! >> >.
>> >
>
>
>.
>

.

Nov 17 '05 #5
Okay, did you add a reference to the assembly in the project, or a "using"
(or "imports" in VB.Net) statement in your code or both?

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:0c****************************@phx.gbl...
The message I get is: "Reference required
to assembly 'System.Xml' containing the implemented
interface 'System.Xml.Serialization.IXmlSerializable'.
Add one to your project." (I removed the path name part of
the message.)

I get this message with or without adding System.Xml.
Under all circumstances I have System.Data. Also, to
clarify, I get the error when building the project as well
as VS.NET has it underlined as an error with the same
message.

Thanks for you help. I'm just dumbfounded since I have
access to the other objects in the namespace. Yeah, I
even tried the 'ol reboot windows trick. I'm running XP
Professional.

Dave

-----Original Message-----
That is indeed odd. What error message do you get when

you add the
reference?

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:09****************************@phx.gbl...
>"So, why don't you just add the reference that
the compiler told you to add?"

Actually, I tried that. Adding 'Imports System.Xml'
doesn't help.

You're right though, System.Data.SqlClient doesn't have
anything to do with the DataSet object. That does just
confuse the issue. However, I am already importing
System.Data and that is the source of my confusion. Why
am I (apparently) getting all the other objects and
methods available to me from the System.Data namespace
except for DataSet?

Thanks,

Dave
>-----Original Message-----
>System.Data.SqlClient has nothing to do with DataSets. A DataSet is not
>provider-specific, so it resides in the System.Data
NameSpace. Adding a
>reference to the Assembly does nothing but make it
available to your app.
>Case in point, adding a reference to
System.Data.SqlClient, which as I
>mentioned, is not necessary. So, why don't you just add
the reference that
>the compiler told you to add?
>
>HTH,
>
>Kevin Spencer
>Microsoft FrontPage MVP
>Internet Developer
>http://www.takempis.com
>Big things are made up of
>lots of Little things.
>
>"Dave" <mi*******@hudnutt.com> wrote in message
>news:09****************************@phx.gbl...
>>
>> I think I understand what you're trying to say. But
>> DataSet, according to all documention I've come across >> (Microsoft, Wrox Books, etc.), says DataSet is part of >> the System.Data namespace. I've also imported
>> System.Data.SqlClient. Both the compilier and
>> Intellisense pick up on other related objects such as
>> DataReader, DataView, DataTable and a host of others.
>> Why not DataSet?
>>
>> Dave
>>
>> >-----Original Message-----
>> >Hi,
>> >
>> >DataSet is a class that enables you to store data on
>> your application
>> >memory and manipulate it. DataSet is made from
>> DataTables and Relations
>> >between them. to Fill DataTable one can use DataAdapter >> of SQLClient,
>> >OLEDB, OracleClient or any other DB connectivity
>> namespace.
>> >
>> >As you see DataSet is not part of any DB namespace it >> is "global" class
>> >that enable you to store data and you can decide what is
>> the source of
>> >that Table.
>> >
>> >The DataSet can be handling as XML file. Actually it
got
>> XSD file
>> >(schema) that set the Tables, fields, relations and
>> other Meta data.
>> >That is the reason way DataSet need reference to
>> System.XML.
>> >
>> >Natty Gur, CTO
>> >Dao2Com Ltd.
>> >28th Baruch Hirsch st. Bnei-Brak
>> >Israel , 51114
>> >
>> >Phone Numbers:
>> >Office: +972-(0)3-5786668
>> >Fax: +972-(0)3-5703475
>> >Mobile: +972-(0)58-888377
>> >
>> >Know the overall picture
>> >
>> >
>> >*** Sent via Developersdex http://www.developersdex.com >> ***
>> >Don't just participate in USENET...get rewarded for it! >> >.
>> >
>
>
>.
>

.

Nov 17 '05 #6
Just an "Import" statement in the code behind the Aspx
form. (I'm using VB for my code.) I have not added a
reference to the assembly. Truth be told I didn't know I
had to add one to the assembly (or how to for that matter
but I can look it up). Would that explain the errant
behavior?

Dave

-----Original Message-----
Okay, did you add a reference to the assembly in the project, or a "using"(or "imports" in VB.Net) statement in your code or both?

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:0c****************************@phx.gbl...
The message I get is: "Reference required
to assembly 'System.Xml' containing the implemented
interface 'System.Xml.Serialization.IXmlSerializable'.
Add one to your project." (I removed the path name part of the message.)

I get this message with or without adding System.Xml.
Under all circumstances I have System.Data. Also, to
clarify, I get the error when building the project as well as VS.NET has it underlined as an error with the same
message.

Thanks for you help. I'm just dumbfounded since I have
access to the other objects in the namespace. Yeah, I
even tried the 'ol reboot windows trick. I'm running XP
Professional.

Dave

>-----Original Message-----
>That is indeed odd. What error message do you get when

you add the
>reference?
>
>HTH,
>
>Kevin Spencer
>Microsoft FrontPage MVP
>Internet Developer
>http://www.takempis.com
>Big things are made up of
>lots of Little things.
>
>"Dave" <mi*******@hudnutt.com> wrote in message
>news:09****************************@phx.gbl...
>> >"So, why don't you just add the reference that
>> the compiler told you to add?"
>>
>> Actually, I tried that. Adding 'Imports System.Xml'
>> doesn't help.
>>
>> You're right though, System.Data.SqlClient doesn't have >> anything to do with the DataSet object. That does just >> confuse the issue. However, I am already importing
>> System.Data and that is the source of my confusion. Why >> am I (apparently) getting all the other objects and
>> methods available to me from the System.Data namespace >> except for DataSet?
>>
>> Thanks,
>>
>> Dave
>>
>>
>> >-----Original Message-----
>> >System.Data.SqlClient has nothing to do with DataSets.
A
>> DataSet is not
>> >provider-specific, so it resides in the System.Data
>> NameSpace. Adding a
>> >reference to the Assembly does nothing but make it
>> available to your app.
>> >Case in point, adding a reference to
>> System.Data.SqlClient, which as I
>> >mentioned, is not necessary. So, why don't you just
add >> the reference that
>> >the compiler told you to add?
>> >
>> >HTH,
>> >
>> >Kevin Spencer
>> >Microsoft FrontPage MVP
>> >Internet Developer
>> >http://www.takempis.com
>> >Big things are made up of
>> >lots of Little things.
>> >
>> >"Dave" <mi*******@hudnutt.com> wrote in message
>> >news:09****************************@phx.gbl...
>> >>
>> >> I think I understand what you're trying to say. But >> >> DataSet, according to all documention I've come

across
>> >> (Microsoft, Wrox Books, etc.), says DataSet is part of
>> >> the System.Data namespace. I've also imported
>> >> System.Data.SqlClient. Both the compilier and
>> >> Intellisense pick up on other related objects
such as >> >> DataReader, DataView, DataTable and a host of others. >> >> Why not DataSet?
>> >>
>> >> Dave
>> >>
>> >> >-----Original Message-----
>> >> >Hi,
>> >> >
>> >> >DataSet is a class that enables you to store data on >> >> your application
>> >> >memory and manipulate it. DataSet is made from
>> >> DataTables and Relations
>> >> >between them. to Fill DataTable one can use

DataAdapter
>> >> of SQLClient,
>> >> >OLEDB, OracleClient or any other DB connectivity
>> >> namespace.
>> >> >
>> >> >As you see DataSet is not part of any DB namespace it
>> >> is "global" class
>> >> >that enable you to store data and you can decide

what
>> is
>> >> the source of
>> >> >that Table.
>> >> >
>> >> >The DataSet can be handling as XML file.
Actually it >> got
>> >> XSD file
>> >> >(schema) that set the Tables, fields, relations and >> >> other Meta data.
>> >> >That is the reason way DataSet need reference to
>> >> System.XML.
>> >> >
>> >> >Natty Gur, CTO
>> >> >Dao2Com Ltd.
>> >> >28th Baruch Hirsch st. Bnei-Brak
>> >> >Israel , 51114
>> >> >
>> >> >Phone Numbers:
>> >> >Office: +972-(0)3-5786668
>> >> >Fax: +972-(0)3-5703475
>> >> >Mobile: +972-(0)58-888377
>> >> >
>> >> >Know the overall picture
>> >> >
>> >> >
>> >> >*** Sent via Developersdex

http://www.developersdex.com
>> >> ***
>> >> >Don't just participate in USENET...get rewarded

for it!
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>

.

Nov 17 '05 #7
Definitely. That's what "Reference" in the error message refers to. Just go
to your Project window, find the "References" element, right-click and
select "Add Reference" from the context menu. Then select the Assembly from
the list of built-in Assemblies. You should be good to go! :)

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:0c****************************@phx.gbl...
Just an "Import" statement in the code behind the Aspx
form. (I'm using VB for my code.) I have not added a
reference to the assembly. Truth be told I didn't know I
had to add one to the assembly (or how to for that matter
but I can look it up). Would that explain the errant
behavior?

Dave

-----Original Message-----
Okay, did you add a reference to the assembly in the

project, or a "using"
(or "imports" in VB.Net) statement in your code or both?

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:0c****************************@phx.gbl...
The message I get is: "Reference required
to assembly 'System.Xml' containing the implemented
interface 'System.Xml.Serialization.IXmlSerializable'.
Add one to your project." (I removed the path name part of the message.)

I get this message with or without adding System.Xml.
Under all circumstances I have System.Data. Also, to
clarify, I get the error when building the project as well as VS.NET has it underlined as an error with the same
message.

Thanks for you help. I'm just dumbfounded since I have
access to the other objects in the namespace. Yeah, I
even tried the 'ol reboot windows trick. I'm running XP
Professional.

Dave
>-----Original Message-----
>That is indeed odd. What error message do you get when
you add the
>reference?
>
>HTH,
>
>Kevin Spencer
>Microsoft FrontPage MVP
>Internet Developer
>http://www.takempis.com
>Big things are made up of
>lots of Little things.
>
>"Dave" <mi*******@hudnutt.com> wrote in message
>news:09****************************@phx.gbl...
>> >"So, why don't you just add the reference that
>> the compiler told you to add?"
>>
>> Actually, I tried that. Adding 'Imports System.Xml'
>> doesn't help.
>>
>> You're right though, System.Data.SqlClient doesn't have >> anything to do with the DataSet object. That does just >> confuse the issue. However, I am already importing
>> System.Data and that is the source of my confusion. Why >> am I (apparently) getting all the other objects and
>> methods available to me from the System.Data namespace >> except for DataSet?
>>
>> Thanks,
>>
>> Dave
>>
>>
>> >-----Original Message-----
>> >System.Data.SqlClient has nothing to do with DataSets. A
>> DataSet is not
>> >provider-specific, so it resides in the System.Data
>> NameSpace. Adding a
>> >reference to the Assembly does nothing but make it
>> available to your app.
>> >Case in point, adding a reference to
>> System.Data.SqlClient, which as I
>> >mentioned, is not necessary. So, why don't you just add >> the reference that
>> >the compiler told you to add?
>> >
>> >HTH,
>> >
>> >Kevin Spencer
>> >Microsoft FrontPage MVP
>> >Internet Developer
>> >http://www.takempis.com
>> >Big things are made up of
>> >lots of Little things.
>> >
>> >"Dave" <mi*******@hudnutt.com> wrote in message
>> >news:09****************************@phx.gbl...
>> >>
>> >> I think I understand what you're trying to say. But >> >> DataSet, according to all documention I've come
across
>> >> (Microsoft, Wrox Books, etc.), says DataSet is part of
>> >> the System.Data namespace. I've also imported
>> >> System.Data.SqlClient. Both the compilier and
>> >> Intellisense pick up on other related objects such as >> >> DataReader, DataView, DataTable and a host of others. >> >> Why not DataSet?
>> >>
>> >> Dave
>> >>
>> >> >-----Original Message-----
>> >> >Hi,
>> >> >
>> >> >DataSet is a class that enables you to store data on >> >> your application
>> >> >memory and manipulate it. DataSet is made from
>> >> DataTables and Relations
>> >> >between them. to Fill DataTable one can use
DataAdapter
>> >> of SQLClient,
>> >> >OLEDB, OracleClient or any other DB connectivity
>> >> namespace.
>> >> >
>> >> >As you see DataSet is not part of any DB namespace it
>> >> is "global" class
>> >> >that enable you to store data and you can decide
what
>> is
>> >> the source of
>> >> >that Table.
>> >> >
>> >> >The DataSet can be handling as XML file. Actually it >> got
>> >> XSD file
>> >> >(schema) that set the Tables, fields, relations and >> >> other Meta data.
>> >> >That is the reason way DataSet need reference to
>> >> System.XML.
>> >> >
>> >> >Natty Gur, CTO
>> >> >Dao2Com Ltd.
>> >> >28th Baruch Hirsch st. Bnei-Brak
>> >> >Israel , 51114
>> >> >
>> >> >Phone Numbers:
>> >> >Office: +972-(0)3-5786668
>> >> >Fax: +972-(0)3-5703475
>> >> >Mobile: +972-(0)58-888377
>> >> >
>> >> >Know the overall picture
>> >> >
>> >> >
>> >> >*** Sent via Developersdex
http://www.developersdex.com
>> >> ***
>> >> >Don't just participate in USENET...get rewarded for it!
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>

.

Nov 17 '05 #8
Hi,

are you sure you got REFERENCE to the 'System.Xml' assembly ?

Natty Gur, CTO
Dao2Com Ltd.
28th Baruch Hirsch st. Bnei-Brak
Israel , 51114

Phone Numbers:
Office: +972-(0)3-5786668
Fax: +972-(0)3-5703475
Mobile: +972-(0)58-888377

Know the overall picture
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 17 '05 #9

Good Gravy I can't believe that worked. So I needed a
reference to System.XML in the assembly but I didn't need
to import it into the Aspx page. Still can't find any
documentation that mentions this but I'll at least know
what to do when the compilier complains again.

Thank you very much Kevin. Amazing how the rest of the
code is falling into place now.

Dave
-----Original Message-----
Definitely. That's what "Reference" in the error message refers to. Just goto your Project window, find the "References" element, right-click andselect "Add Reference" from the context menu. Then select the Assembly fromthe list of built-in Assemblies. You should be good to go! :)
HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
http://www.takempis.com
Big things are made up of
lots of Little things.

"Dave" <mi*******@hudnutt.com> wrote in message
news:0c****************************@phx.gbl...
Just an "Import" statement in the code behind the Aspx
form. (I'm using VB for my code.) I have not added a
reference to the assembly. Truth be told I didn't know I had to add one to the assembly (or how to for that matter but I can look it up). Would that explain the errant
behavior?

Dave

>-----Original Message-----
>Okay, did you add a reference to the assembly in the

project, or a "using"
>(or "imports" in VB.Net) statement in your code or both? >
>HTH,
>
>Kevin Spencer
>Microsoft FrontPage MVP
>Internet Developer
>http://www.takempis.com
>Big things are made up of
>lots of Little things.
>
>"Dave" <mi*******@hudnutt.com> wrote in message
>news:0c****************************@phx.gbl...
>> The message I get is: "Reference required
>> to assembly 'System.Xml' containing the implemented
>> interface 'System.Xml.Serialization.IXmlSerializable'. >> Add one to your project." (I removed the path name part
of
>> the message.)
>>
>> I get this message with or without adding System.Xml.
>> Under all circumstances I have System.Data. Also, to
>> clarify, I get the error when building the project as

well
>> as VS.NET has it underlined as an error with the same
>> message.
>>
>> Thanks for you help. I'm just dumbfounded since I
have >> access to the other objects in the namespace. Yeah, I >> even tried the 'ol reboot windows trick. I'm running XP >> Professional.
>>
>> Dave
>>
>>
>> >-----Original Message-----
>> >That is indeed odd. What error message do you get when >> you add the
>> >reference?
>> >
>> >HTH,
>> >
>> >Kevin Spencer
>> >Microsoft FrontPage MVP
>> >Internet Developer
>> >http://www.takempis.com
>> >Big things are made up of
>> >lots of Little things.
>> >
>> >"Dave" <mi*******@hudnutt.com> wrote in message
>> >news:09****************************@phx.gbl...
>> >> >"So, why don't you just add the reference that
>> >> the compiler told you to add?"
>> >>
>> >> Actually, I tried that. Adding 'Imports System.Xml' >> >> doesn't help.
>> >>
>> >> You're right though, System.Data.SqlClient doesn't

have
>> >> anything to do with the DataSet object. That does

just
>> >> confuse the issue. However, I am already importing >> >> System.Data and that is the source of my confusion. Why
>> >> am I (apparently) getting all the other objects
and >> >> methods available to me from the System.Data

namespace
>> >> except for DataSet?
>> >>
>> >> Thanks,
>> >>
>> >> Dave
>> >>
>> >>
>> >> >-----Original Message-----
>> >> >System.Data.SqlClient has nothing to do with

DataSets.
>> A
>> >> DataSet is not
>> >> >provider-specific, so it resides in the System.Data >> >> NameSpace. Adding a
>> >> >reference to the Assembly does nothing but make it >> >> available to your app.
>> >> >Case in point, adding a reference to
>> >> System.Data.SqlClient, which as I
>> >> >mentioned, is not necessary. So, why don't you just add
>> >> the reference that
>> >> >the compiler told you to add?
>> >> >
>> >> >HTH,
>> >> >
>> >> >Kevin Spencer
>> >> >Microsoft FrontPage MVP
>> >> >Internet Developer
>> >> >http://www.takempis.com
>> >> >Big things are made up of
>> >> >lots of Little things.
>> >> >
>> >> >"Dave" <mi*******@hudnutt.com> wrote in message
>> >> >news:09****************************@phx.gbl...
>> >> >>
>> >> >> I think I understand what you're trying to say.

But
>> >> >> DataSet, according to all documention I've come
>> across
>> >> >> (Microsoft, Wrox Books, etc.), says DataSet is

part
>> of
>> >> >> the System.Data namespace. I've also imported
>> >> >> System.Data.SqlClient. Both the compilier and
>> >> >> Intellisense pick up on other related objects

such as
>> >> >> DataReader, DataView, DataTable and a host of

others.
>> >> >> Why not DataSet?
>> >> >>
>> >> >> Dave
>> >> >>
>> >> >> >-----Original Message-----
>> >> >> >Hi,
>> >> >> >
>> >> >> >DataSet is a class that enables you to store

data on
>> >> >> your application
>> >> >> >memory and manipulate it. DataSet is made from
>> >> >> DataTables and Relations
>> >> >> >between them. to Fill DataTable one can use
>> DataAdapter
>> >> >> of SQLClient,
>> >> >> >OLEDB, OracleClient or any other DB
connectivity >> >> >> namespace.
>> >> >> >
>> >> >> >As you see DataSet is not part of any DB

namespace
>> it
>> >> >> is "global" class
>> >> >> >that enable you to store data and you can decide >> what
>> >> is
>> >> >> the source of
>> >> >> >that Table.
>> >> >> >
>> >> >> >The DataSet can be handling as XML file.

Actually it
>> >> got
>> >> >> XSD file
>> >> >> >(schema) that set the Tables, fields, relations and
>> >> >> other Meta data.
>> >> >> >That is the reason way DataSet need reference
to >> >> >> System.XML.
>> >> >> >
>> >> >> >Natty Gur, CTO
>> >> >> >Dao2Com Ltd.
>> >> >> >28th Baruch Hirsch st. Bnei-Brak
>> >> >> >Israel , 51114
>> >> >> >
>> >> >> >Phone Numbers:
>> >> >> >Office: +972-(0)3-5786668
>> >> >> >Fax: +972-(0)3-5703475
>> >> >> >Mobile: +972-(0)58-888377
>> >> >> >
>> >> >> >Know the overall picture
>> >> >> >
>> >> >> >
>> >> >> >*** Sent via Developersdex
>> http://www.developersdex.com
>> >> >> ***
>> >> >> >Don't just participate in USENET...get

rewarded for
>> it!
>> >> >> >.
>> >> >> >
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>

.

Nov 17 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: John Holmes | last post by:
I have a web interface where the user types in ID's one at a time. After an ID is typed in, a button is clicked and the button click event has code that does a query and returns a data reader and...
2
by: Larry Stewart | last post by:
I am using VS.NET 2003 and I have a simple WinForm that uses a SQLConnection, SQLAdapter, and a DataSet. I am binding the DataSet values to TextBoxes ( I don't want a grid for this situation). ...
16
by: SimonYingling | last post by:
I'm a young programmer, but definitly see my self doing this for the rest of my life. I'm 15 and into C++. I was wondering if a good compilier for Windows would be Visual C++ 6.0. I have used Dev...
2
by: Todd | last post by:
I am desperately trying to figure out the following problem, simplified for discussion. I have a WinForm with a button, textbox, and datagrid. When I click the button, I want to execute the...
3
by: JJ | last post by:
Hi, I need to pass a dataset to another win form along with a SqldataAdapter. I don't want to recreate the SqlDataAdapter again either. So to pass to another Win form in my windows form app, do...
1
by: J. Askey | last post by:
I am implementing a web service and thought it may be a good idea to return a more complex class (which I have called 'ServiceResponse') in order to wrap the original return value along with two...
0
by: Derek Vincent | last post by:
Why am I having problems filling my dataset when I select fields of type varchar(350) from interbase? I can fill the dataset when I select every other field in the table but I receive and error...
1
by: matt | last post by:
hello, i have a web app that allows users to query our oracle db and produce a dataset of report data. they then have the option to serialize this data and store it in the database. later, then...
10
by: mirandacascade | last post by:
Question toward the bottom of this post....background information immediately below. Access 97 SQL Server 2000 Please note: although the subject line uses the word 'bloat', this post is NOT...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.