Gridview Issue with Selecting Row for SQL Stored Procedure

[oldmanbernie]

On every row of a gridview, I want to add a button that will invoke a SQL Stored Procedure. One of the parameters I need for the stored procedure is on one of the columns of the gridview based on the corresponding row. How do I go about adding that parameter in the following form:

SqlCmd.Parameters.Add(new SqlParameter("@foo", ???);

 

[ca8msm]

Create a button in the GridView, add a commandargument to it (with the value set to the same as the value you need to pass) and then use the ItemCommand event to fire off your stored procedure (the value will be in e.CommandArgument).


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]