Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C# - Add and Update Records
Message
From
13/04/2008 17:32:33
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01309187
Message ID:
01310306
Views:
46
>>>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?

Kevin,
Check out my other answer and see if that helps. I am not familiar with the visualizer, but you can inspect this during debug to see what the objects are. The table is contained in the dataset. See if you actually are getting two tables or not.
Tim
Timothy Bryan
Previous
Reply
Map
View

Click here to load this message in the networking platform