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 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!
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 . .
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 notprovider-specific, so it resides in the System.Data NameSpace. Adding areference 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 Imentioned, is not necessary. So, why don't you just add the reference thatthe 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! >. >
.
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! >> >. >> > > > >. >
.
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 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! >> >. >> > > > >. >
.
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! >> >> >. >> >> > >> > >> > >> >. >> > > > >. >
.
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! >> >> >. >> >> > >> > >> > >> >. >> > > > >. >
.
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!
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! >> >> >> >. >> >> >> > >> >> > >> >> > >> >> >. >> >> > >> > >> > >> >. >> > > > >. >
. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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.
|
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...
|
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...
|
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...
| |
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;
|
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.
...
|
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...
|
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...
|
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...
|
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. ...
| |
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...
|
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |