Compilier will not recognize DataSet object.

Ask a Question related to ASP.NET General, Design and Development.

  1. #1

    Default Compilier will not recognize DataSet object.

    Compilier will not recognize DataSet object.

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

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

    Thanks,

    Dave


    Imports System.Data
    Imports System.Data.SqlClient

    Public Class WebForm1
    Inherits System.Web.UI.Page
    Protected WithEvents DataSet1 As System.Data.DataSet


    Private Sub Page_Load(ByVal sender As System.Object,
    ByVal e As System.EventArgs) Handles MyBase.Load

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

    End Sub

    End Class
    Dave Guest

  2. Similar Questions and Discussions

    1. Not able to recognize flextree object which loads imagesfrom external location
      Hi All, I am doing automation testing using QTP9.2 on Flex application which is developed on Flex bulder 3.0. Issue: There are Flextree...
    2. Update packet does not recognize dataset changes
      If I make a change via actionscript to a field in a dataset (e.g. dataset.currentItem.myField = whatever) the change shows up fine in the dataset...
    3. dataset.Databind error when dataset XML contains attributes...
      I've come accross an interesting problem populating an asp.net datagrid. I am trying to bind XML data to a datagrid as I've done in countless other...
    4. HOW TO: Create a single DataSet bound object used by 50 DropDownList box controls in the same web form. CSHARP
      I have a seating chart web form that has over 50 entry field controls (tables/booths) where I use a DropDownList box to select a single company...
    5. Ccopying a datatable content from an untyped dataset into a table which is inside a typed dataset
      Hi All, I am facing problem in copying content of table from a untyped dataset into to a table inside the typed dataset. I wanted to copy the data...
  3. #2

    Default Re: Compilier will not recognize DataSet object.

    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 [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Natty Gur Guest

  4. #3

    Default Compilier will not recognize DataSet object.


    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
    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
    >>.
    >>
    >.
    >
    Dave Guest

  5. #4

    Default Re: Compilier will not recognize DataSet object.


    If you look you see that DataSet is part of System.Data. This namespace
    is "base" namespace for actual DB connectivity Namespace that actually
    implement Interfaces that declared in the System.Data namespace. if you
    check system.data you will find IDataAdapter, IDataReader, IDBCommand
    and more. those interfaces implement by SQL, OLEDB or OracleClient
    (SQLDataAdapter, OLEDataAdapter, and so). What I try to say is that
    System.Data hold declaration that aren’t specific to certain DB, on the
    contrary other data namespaces (System.Data.*) are DB specific. Now
    DataSet isn’t DB specific it just hold data in specific format and that
    is the reason MS put it in System.Data namespace.

    DataSet is part of System.Data Namespace but if you don’t have reference
    to System.XML you cant see it in neither your Intellisense nor compiling
    the project. (The DataSet class reference System.XML and that the reason
    you need to do it)

    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 [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Natty Gur Guest

  6. #5

    Default Re: Compilier will not recognize DataSet object.

    That is indeed odd. What error message do you get when you add the
    reference?

    HTH,

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

    "Dave" <microsoft@hudnutt.com> wrote in message
    news:09ec01c33b17$1f00f970$a501280a@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
    > >[url]http://www.takempis.com[/url]
    > >Big things are made up of
    > >lots of Little things.
    > >
    > >"Dave" <microsoft@hudnutt.com> wrote in message
    > >news:092501c33b0c$9d988290$a501280a@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 [url]http://www.developersdex.com[/url]
    > >> ***
    > >> >Don't just participate in USENET...get rewarded for it!
    > >> >.
    > >> >
    > >
    > >
    > >.
    > >

    Kevin Spencer Guest

  7. #6

    Default Re: Compilier will not recognize DataSet object.

    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
    >[url]http://www.takempis.com[/url]
    >Big things are made up of
    >lots of Little things.
    >
    >"Dave" <microsoft@hudnutt.com> wrote in message
    >news:09ec01c33b17$1f00f970$a501280a@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
    >> >[url]http://www.takempis.com[/url]
    >> >Big things are made up of
    >> >lots of Little things.
    >> >
    >> >"Dave" <microsoft@hudnutt.com> wrote in message
    >> >news:092501c33b0c$9d988290$a501280a@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
    [url]http://www.developersdex.com[/url]
    >> >> ***
    >> >> >Don't just participate in USENET...get rewarded for
    it!
    >> >> >.
    >> >> >
    >> >
    >> >
    >> >.
    >> >
    >
    >
    >.
    >
    Dave Guest

  8. #7

    Default Re: Compilier will not recognize DataSet object.

    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
    [url]http://www.takempis.com[/url]
    Big things are made up of
    lots of Little things.

    "Dave" <microsoft@hudnutt.com> wrote in message
    news:0cd501c33b2d$e2828ec0$a401280a@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
    > >[url]http://www.takempis.com[/url]
    > >Big things are made up of
    > >lots of Little things.
    > >
    > >"Dave" <microsoft@hudnutt.com> wrote in message
    > >news:09ec01c33b17$1f00f970$a501280a@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
    > >> >[url]http://www.takempis.com[/url]
    > >> >Big things are made up of
    > >> >lots of Little things.
    > >> >
    > >> >"Dave" <microsoft@hudnutt.com> wrote in message
    > >> >news:092501c33b0c$9d988290$a501280a@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
    > [url]http://www.developersdex.com[/url]
    > >> >> ***
    > >> >> >Don't just participate in USENET...get rewarded for
    > it!
    > >> >> >.
    > >> >> >
    > >> >
    > >> >
    > >> >.
    > >> >
    > >
    > >
    > >.
    > >

    Kevin Spencer Guest

  9. #8

    Default Re: Compilier will not recognize DataSet object.

    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
    >[url]http://www.takempis.com[/url]
    >Big things are made up of
    >lots of Little things.
    >
    >"Dave" <microsoft@hudnutt.com> wrote in message
    >news:0cd501c33b2d$e2828ec0$a401280a@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
    >> >[url]http://www.takempis.com[/url]
    >> >Big things are made up of
    >> >lots of Little things.
    >> >
    >> >"Dave" <microsoft@hudnutt.com> wrote in message
    >> >news:09ec01c33b17$1f00f970$a501280a@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
    >> >> >[url]http://www.takempis.com[/url]
    >> >> >Big things are made up of
    >> >> >lots of Little things.
    >> >> >
    >> >> >"Dave" <microsoft@hudnutt.com> wrote in message
    >> >> >news:092501c33b0c$9d988290$a501280a@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
    >> [url]http://www.developersdex.com[/url]
    >> >> >> ***
    >> >> >> >Don't just participate in USENET...get rewarded
    for
    >> it!
    >> >> >> >.
    >> >> >> >
    >> >> >
    >> >> >
    >> >> >.
    >> >> >
    >> >
    >> >
    >> >.
    >> >
    >
    >
    >.
    >
    Dave Guest

  10. #9

    Default Re: Compilier will not recognize DataSet object.

    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
    [url]http://www.takempis.com[/url]
    Big things are made up of
    lots of Little things.

    "Dave" <microsoft@hudnutt.com> wrote in message
    news:0c4c01c33b56$568181a0$a001280a@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
    > >[url]http://www.takempis.com[/url]
    > >Big things are made up of
    > >lots of Little things.
    > >
    > >"Dave" <microsoft@hudnutt.com> wrote in message
    > >news:0cd501c33b2d$e2828ec0$a401280a@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
    > >> >[url]http://www.takempis.com[/url]
    > >> >Big things are made up of
    > >> >lots of Little things.
    > >> >
    > >> >"Dave" <microsoft@hudnutt.com> wrote in message
    > >> >news:09ec01c33b17$1f00f970$a501280a@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
    > >> >> >[url]http://www.takempis.com[/url]
    > >> >> >Big things are made up of
    > >> >> >lots of Little things.
    > >> >> >
    > >> >> >"Dave" <microsoft@hudnutt.com> wrote in message
    > >> >> >news:092501c33b0c$9d988290$a501280a@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
    > >> [url]http://www.developersdex.com[/url]
    > >> >> >> ***
    > >> >> >> >Don't just participate in USENET...get rewarded
    > for
    > >> it!
    > >> >> >> >.
    > >> >> >> >
    > >> >> >
    > >> >> >
    > >> >> >.
    > >> >> >
    > >> >
    > >> >
    > >> >.
    > >> >
    > >
    > >
    > >.
    > >

    Kevin Spencer Guest

  11. #10

    Default Re: Compilier will not recognize DataSet object.

    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 [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Natty Gur Guest

  12. #11

    Default Re: Compilier will not recognize DataSet object.


    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 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
    >[url]http://www.takempis.com[/url]
    >Big things are made up of
    >lots of Little things.
    >
    >"Dave" <microsoft@hudnutt.com> wrote in message
    >news:0c4c01c33b56$568181a0$a001280a@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
    >> >[url]http://www.takempis.com[/url]
    >> >Big things are made up of
    >> >lots of Little things.
    >> >
    >> >"Dave" <microsoft@hudnutt.com> wrote in message
    >> >news:0cd501c33b2d$e2828ec0$a401280a@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
    >> >> >[url]http://www.takempis.com[/url]
    >> >> >Big things are made up of
    >> >> >lots of Little things.
    >> >> >
    >> >> >"Dave" <microsoft@hudnutt.com> wrote in message
    >> >> >news:09ec01c33b17$1f00f970$a501280a@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
    >> >> >> >[url]http://www.takempis.com[/url]
    >> >> >> >Big things are made up of
    >> >> >> >lots of Little things.
    >> >> >> >
    >> >> >> >"Dave" <microsoft@hudnutt.com> wrote in message
    >> >> >> >news:092501c33b0c$9d988290$a501280a@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
    >> >> [url]http://www.developersdex.com[/url]
    >> >> >> >> ***
    >> >> >> >> >Don't just participate in USENET...get
    rewarded
    >> for
    >> >> it!
    >> >> >> >> >.
    >> >> >> >> >
    >> >> >> >
    >> >> >> >
    >> >> >> >.
    >> >> >> >
    >> >> >
    >> >> >
    >> >> >.
    >> >> >
    >> >
    >> >
    >> >.
    >> >
    >
    >
    >.
    >
    Dave Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139