Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C# - Add and Update Records
Message
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Miscellaneous
Thread ID:
01309187
Message ID:
01310198
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform