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 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!
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 . .
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 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.SqlClient, 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*******@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! >. >
.
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! >> >. >> > > > >. >
.
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 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! >> >. >> > > > >. >
.
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! >> >> >. >> >> > >> > >> > >> >. >> > > > >. >
.
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! >> >> >. >> >> > >> > >> > >> >. >> > > > >. >
.
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*******@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! >> >> >> >. >> >> >> > >> >> > >> >> > >> >> >. >> >> > >> > >> > >> >. >> > > > >. >
. 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...
|
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).
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
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...
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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...
| |