hi there; using asp.net (c#, 3.5) i would like to send my stored procedure a value (ie. myPage) and have my stored procedure:
1. select the record that pertains to this value in my hit counter table,
2. update the current stored value by 1
3. return the new value to my .aspx page
here is my existing code:
string strMyPage= txtMyPage.Text;
string strConnection = ConfigurationSettings.AppSettings["myDB"];
SqlConnection myConnection = new SqlConnection(strConnection);
SqlCommand myCommand = new SqlCommand("CSP_Update_HitCounter", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@myPage", SqlDbType.Text).Value = strMyPage;
SET @count = fldCount + 1
/* SET NOCOUNT ON */
This is my best crack at it but isn't quite right. Also not sure how to retrieve the returned value in my asp.cs page.
suggestions? thanks all.