updating db via SqlDataSource

L

Loading name...

hey

asp.net 2.0

I have a GridView which get its data from a SqlDataSource object on the
webpage. This GridView consist of 1 column (I removed the id column because
the user don't need to see it. Maybe the Update need this column?)

I have enabled updating on the GridView. In Sql Server 2005 I created a new
stored procedure which takes 2 parameters: id and the new value.

My problem is that I don't know how to specify the parameter.for the "new
value", I know how to specify the id (using command and parameter editor)

How do I specify the parameter for this "new value" (the change the user
made to the field)?

Maybe there is a better way of doing this, please come with suggestion

Best Regards
 
L

Loading name...

Loading name... said:
hey

asp.net 2.0

I have a GridView which get its data from a SqlDataSource object on the
webpage. This GridView consist of 1 column (I removed the id column
because the user don't need to see it. Maybe the Update need this column?)

I have enabled updating on the GridView. In Sql Server 2005 I created a
new stored procedure which takes 2 parameters: id and the new value.

My problem is that I don't know how to specify the parameter.for the "new
value", I know how to specify the id (using command and parameter editor)

How do I specify the parameter for this "new value" (the change the user
made to the field)?

Maybe there is a better way of doing this, please come with suggestion

Best Regards
 

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,770
Messages
2,569,583
Members
45,075
Latest member
MakersCBDBloodSupport

Latest Threads

Top