473,586 Members | 2,566 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.Sql Client. 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.Ser ialization.IXml Serializable'.
Add one to your project.

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

Thanks,

Dave
Imports System.Data
Imports System.Data.Sql Client

Public Class WebForm1
Inherits System.Web.UI.P age
Protected WithEvents DataSet1 As System.Data.Dat aSet
Private Sub Page_Load(ByVal sender As System.Object,
ByVal e As System.EventArg s) 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 2262
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.Sql Client
(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.Sql Client. 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.Ser ialization.IXml Serializable'.
Add one to your project.

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

Thanks,

Dave
Imports System.Data
Imports System.Data.Sql Client

Public Class WebForm1
Inherits System.Web.UI.P age
Protected WithEvents DataSet1 As System.Data.Dat aSet
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArg s) 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*******@hudn utt.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.Sql Client 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.Sq lClient 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.Sql Client, 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*******@hudn utt.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.Sql Client. 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.Ser ialization.IXml Serializable'.
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*******@hudn utt.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.Sql Client 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.Sq lClient 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.Sql Client, 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*******@hudn utt.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.Sql Client. 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*******@hudn utt.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.Ser ialization.IXml Serializable'.
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*******@hudn utt.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.Sql Client 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.Sq lClient 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.Sql Client, 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*******@hudn utt.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.Sql Client. 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*******@hudn utt.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.Ser ialization.IXml Serializable'.
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*******@hudn utt.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.Sql Client 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.Sq lClient 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.Sql Client, 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*******@hudn utt.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.Sql Client. 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*******@hudn utt.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*******@hudn utt.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.Ser ialization.IXml Serializable'.
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*******@hudn utt.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.Sql Client 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.Sq lClient 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.Sql Client, 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*******@hudn utt.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.Sql Client. 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*******@hudn utt.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*******@hudn utt.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.Ser ialization.IXml Serializable'. >> 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*******@hudn utt.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.Sql Client 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.Sq lClient 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.Sql Client, 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*******@hudn utt.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.Sql Client. 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
6163
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 then appends the data to a dataset that is built in the Page_Load code in the if(!isPostBack) block. When I try to add a row in the button click...
2
284
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). The problem is that I can not get the dataSet to recognize the user has changed a textbox field without going to a different row.
16
1526
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 C++ and Turbo C++ (at school =x) and am lucking into a better compilier now that I have money to spend. Any comments are accepted, even if they are...
2
1423
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 method defined in the textbox, which must return a dataset, and pass this dataset to the datasource of my datagrid. Delegates and/or Reflection seem...
3
13579
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 I create the procedure to pass by ref? Which means I don't need to add ByRef because it is defaulted by ref, correct? And in the constructor of the...
1
5538
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 other properties... bool error; string lastError; My whole class looks like this... using System;
0
1421
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 message that says "object reference not set to an instance of an object" when I return the varchar field." The detailed error message is below. ...
1
2515
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 can re-run the report and get fresh data. now, they would like to be able to compare the fresh data to the stored data, getting a break-down of...
10
1753
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 a "what can I do to prevent bloat?" inquiry. When I searched the postings in this group for information about bloat, I believe I gained a...
0
7912
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8202
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7959
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8216
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6614
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5390
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3837
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3865
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1449
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.