Datagrid ADO.Net dataset update record

Question

hello vb genius,

i'm good in programming but not too familiar with ado.net. I'm trying to make a simple application using mssql server, ado.net, .net 3.5 and sp's

I have following question

1. created a table with 2 fields (id , name) id is pk
2. created sp to add, delete, update/insert record in table.
3. created a form and shown two text fields to show the data from table and a grid to show all the record on the same form. 2 buttons added on the form new and save
4. create sqlconnection to server, create data adapter and set the data adapter insert, select and update command alongwith parameters and filled the data source.
5. bound the grid runtime with datasource and table.
6. on cellclick of datagrid, i get the record from grid and show the value in text fields. even grid is sorted, it is working find, i found some function from internet to achieve it.
7. on click of new button, i clear the text fields and internally set a boolean variable for new record.
8. on click of save button, if boolean varaible is true then add new row to dataset table and accept the changes.
9. it adds the record in table and show it in grid.


till this point everything worked fine.

the issue i'm facing is when user select a record from grid and do the changes on text field, on click of save, it need to update the record.

as i have boolean variable which tell me if it is exisiting or new record but i'm unable to find out the way to update the record.

there is a way i can do it, if i know the current record number in table of data set. in this case i can set the value of table coloumsn of that row and accept changes

but i have no way to get the row of the table becuase if grid is sorted then i don't have correct correspoding record number in data table.

how i can achieve this functionality? In a nutshell, if i able to get corresponding record number of table in dataset on basis of current selected grid record, it will solve the above problem.

at the same time i'm open for any or most practical approach.

any idea?

thanks in advance,

p