How to define the parameter in UPDATE statement in DataGrid

L

Luke Xu

I start learning asp.net 2.0. When I try to use Edit function in DataGrid to
update database (DB2), how can I put parameter there?

For example, there are two columns EMP_ID, EMP_NAME. I want to update
employee name and issue the SQL statement in data source:

UPDATE EMPLOYEE SET EMP_NAME=?? WHERE EMP_ID=??

What I need to put into ?? ?

In Command and Parameter Editor of ASP.NET, how can I bind the new parameter
with the field in data grid?


Thanks
Luke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top