I don't know what happened with this post, you can ignore it and read the post that actually posted.
Tim
>>>>Tim & Bonnie:
>>>>
>>>>I am sure that I'm totally lost here, and I'm not sure that I'm communicating the problem clearly.
>>>>
>>>>I created a simple project with a Test DB and a Customers table and called the project Typed_DS_Example.
>>>>There is a simple Typed Dataset called DSCustomers in the project. The code loads it from the SQL Customers table. The project is here:
>>>>
http://www.geocities.com/kevin.marois/typed_ds/typed_ds_example.zip>>>>The DB is in the Data folder.
>>>>
>>>>
>>>>Please see these 2 pics:
>>>>
>>>>In the first, you can see that there is an object in the Visualizer called 'DSCustomers'. The structure
>>>>is correct, but there is no data.
>>>>
http://www.geocities.com/kevin.marois/typed_ds/visualizer1.jpg>>>>
>>>>
>>>>In the second, you can see that there is another object in the Visualizer called 'Customers'. The structure is correct, and there
is data.
>>>>
http://www.geocities.com/kevin.marois/typed_ds/visualizer2.jpg>>>>
>>>>Now I don't know if this is what is supposed to be happening. I have no experience at all using a
>>>>typed dataset. If this is not correct, then can you show me what's wrong? If it IS correct, the how
>>>>do I use this dataset to Add, Edit and Delete a customer?
>>>>
>>>>Signed, Frustrated In California :)
>>>>
>>>
>>>Think of it like this:
>>>
>>>DataSets (DataBases) Contain Tables
>>>Tables Contain Rows (Records)
>>>Records Contain Columns (Fields)
>>>
>>>>>how do I use this dataset to Add, Edit and Delete a customer?
>>>
>>>Something like this:
>>>
>>>
>>>DSCustomer ds = new DSCustomer();
>>>DSCustomer.CustomersDataTable tbl = ds.Customers;
>>>DSCustomer.CustomersRow row = ds.Customers.NewCustomersRow();
>>>
>>>//Add
>>>tbl.Rows.Add(row);
>>>
>>>//Edit
>>>row.CustomerName = "";
>>>
>>>//Delete
>>>row.Delete();
>>>
>>>
>>>also:
http://msdn2.microsoft.com/en-us/library/ms171928(VS.80).aspx>>
>>
>>This STILL has not answered my question. Why do I see 2 objects in the DataSet Visualizer? What are these objects?
>
>One is the >>>Tim & Bonnie:
>>>>
>>>>I am sure that I'm totally lost here, and I'm not sure that I'm communicating the problem clearly.
>>>>
>>>>I created a simple project with a Test DB and a Customers table and called the project Typed_DS_Example.
>>>>There is a simple Typed Dataset called DSCustomers in the project. The code loads it from the SQL Customers table. The project is here:
>>>>
http://www.geocities.com/kevin.marois/typed_ds/typed_ds_example.zip>>>>The DB is in the Data folder.
>>>>
>>>>
>>>>Please see these 2 pics:
>>>>
>>>>In the first, you can see that there is an object in the Visualizer called 'DSCustomers'. The structure
>>>>is correct, but there is no data.
>>>>
http://www.geocities.com/kevin.marois/typed_ds/visualizer1.jpg>>>>
>>>>
>>>>In the second, you can see that there is another object in the Visualizer called 'Customers'. The structure is correct, and there
is data.
>>>>
http://www.geocities.com/kevin.marois/typed_ds/visualizer2.jpg>>>>
>>>>Now I don't know if this is what is supposed to be happening. I have no experience at all using a
>>>>typed dataset. If this is not correct, then can you show me what's wrong? If it IS correct, the how
>>>>do I use this dataset to Add, Edit and Delete a customer?
>>>>
>>>>Signed, Frustrated In California :)
>>>>
>>>
>>>Think of it like this:
>>>
>>>DataSets (DataBases) Contain Tables
>>>Tables Contain Rows (Records)
>>>Records Contain Columns (Fields)
>>>
>>>>>how do I use this dataset to Add, Edit and Delete a customer?
>>>
>>>Something like this:
>>>
>>>
>>>DSCustomer ds = new DSCustomer();
>>>DSCustomer.CustomersDataTable tbl = ds.Customers;
>>>DSCustomer.CustomersRow row = ds.Customers.NewCustomersRow();
>>>
>>>//Add
>>>tbl.Rows.Add(row);
>>>
>>>//Edit
>>>row.CustomerName = "";
>>>
>>>//Delete
>>>row.Delete();
>>>
>>>
>>>also:
http://msdn2.microsoft.com/en-us/library/ms171928(VS.80).aspx>>
>>
>>This STILL has not answered my question. Why do I see 2 objects in the DataSet Visualizer? What are these objects?
>
>They are tables in the dataset.
>
>One is the typed DSCustomers table you created in your dataset the other is the Customers table you created when you executed this command:
>
>oDataAdapter.Fill(oDataSet, "Customers")
>
>instead of this one which would have filled the DSCustomers table:
>
>oDataAdapter.Fill(oDataSet.DSCustomers);
Timothy Bryan