Update command in SQLDataSource
Hello all,
I am using SQL dsatasource to bind the grid view. Now I am trying to eable update in the datagrid. The way I want is that of somebody updates the value in the Grid then it should be reflected in the database in the back.
I have some simple query like
update X
set Column1 = @NewvalueColumn1
where
oldvalueColumn2= 'something'
Now here, where do I specify @NewvalueColumn1? Because that is somevalue coming from the Grid. How do I read that value?
I am using SQL dsatasource to bind the grid view. Now I am trying to eable update in the datagrid. The way I want is that of somebody updates the value in the Grid then it should be reflected in the database in the back.
I have some simple query like
update X
set Column1 = @NewvalueColumn1
where
oldvalueColumn2= 'something'
Now here, where do I specify @NewvalueColumn1? Because that is somevalue coming from the Grid. How do I read that value?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That's what my question is thatwhen you say "The "@NewvalueColumn1" can only be found from the current row of the Grid."
How can I read the current row in Datagrid?