is there a way to use DataTable and linked it to the database without using the dataset ??


i have a datatable that i populate using the load from a Datareadermethod


DataTable MyTable = new DataTable();

reader1 = SQlcommand1.executeReader();

MyTable.load(reader1);


i need to update the table and change the actual data in the database. please help

If you are using TableAdapters (and the data designers), it will generate code for you that can perform updates.

If not (and many of us don't), then you will need to write code to perform your updates.

I have an example here using a SQL statement to perform an update:

http://msmvps.com/blogs/deborahk/archive/2009/08/21/dal-save-data-using-a-sql-statement.aspx

I have an example here using a stored procedure to perform an update:

http://msmvps.com/blogs/deborahk/archive/2009/08/14/dal-save-data-using-a-stored-procedure.aspx

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

If you are using TableAdapters (and the data designers), it will generate code for you that can perform updates.

If not (and many of us don't), then you will need to write code to perform your updates.

I have an example here using a SQL statement to perform an update:

http://msmvps.com/blogs/deborahk/archive/2009/08/21/dal-save-data-using-a-sql-statement.aspx

I have an example here using a stored procedure to perform an update:

http://msmvps.com/blogs/deborahk/archive/2009/08/14/dal-save-data-using-a-stored-procedure.aspx

Hope this helps.

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!