[RESOLVED] Update Dataset and database Table

[kumar_1981]

Hai

i am working with winforms and c# 2005.


in ui i am making multiple record updations and sending as a DataTable


Now how should i update dataset with modified data and how should i add those in Database. i should update multiple records at a time in Database.


Thanks and Regards
Vinay Kumar

[jmcilhinney]

Presumably you used a DataAdapter or TableAdapter and called its Fill method to retrieve the data in the first place. You now use the same adapter and call its Update method to save the changes.

[kumar_1981]

Hai.Thanks for the reply


i am having a Dataset

dsTest with Table "Config"

i got this using Adapter

oledbTest.Fill(dsTest,"Config");

Now i did modifications in the UI and i need to update those values to Dataset first , then i need to Update in the Database.


My Problem is how to Update Dataset??i need to update multiple records with one click event.




Thanks and Regards
Vinay Kumar

[fifo]

hey, i see.
Firstly, if you want to update multil Rows from DS into DB, you MUST creat Command Updated for DataAdapter.

Secondly, each DataAdapter have Commands for just only a Table.

Try!