how do i update a sql database from a datagrid.
Posted on 2006-05-09
i have a form with a datagrid populated with a dataset, a sqdataAdapter and a datatable. the form works great and the grid and all the other controlls are bound and working fine. my problem is that the are two views of the data. one view is the detailed view wich is on a tab control with textboxes and dropdaown list's, the other view i sthat of the datgrid. the problem lies in updating changes i make to the data i can only save or update the database with the 1st view with text boxes which i can only update one row at a time. for speed i would like to be able to make changes in the datagrid on multiple rows and save those changes to the datbase. i have tried some textbook examples but nothing eems to work does anyone have any code examples of how this can be achieved.