Regarding ADO.Net

I have fetched some 1000 records using data adaptor and displayed in the UI(DataGrid). Now whenever user is changing the value in anyone of the row in the data grid, that particular va开发者_如何转开发lue has to be updated into database table. Currently i am dumping the entire table again using adaptor.update. i dont want to do that...i just want to update only that row..how can i achieve this .?? can anybody help regarding this ?

You can get and pass to adapter only changed rows by calling DataSet.GetChanges() or DataTable.GetChanges methods