I'm trying to use a parameterized SELECT statement, but I must not have it right - the code below gives this compile error: System.Data.SqlClient.SqlException: Must declare the scalar variable "@.UserID".
string
strUserID = (string)Session["UserID"];string strSelectRatings ="SELECT [CommentID], [GameID], [UserID], [Rating], LEFT(Comment,40) as Comment FROM [Comments] WHERE [UserID] = @.UserID";SqlConnection myConnection =newSqlConnection("...");SqlCommand myCommand =newSqlCommand(strSelectRatings, myConnection);myCommand.Parameters.Add(
"@.UserID", strUserID);MySqlDataSource.SelectCommand = strSelectRatings;
GridView1.DataBind();
Add the parameters to your SqlDataSource object
MySqlDataSource.SelectParameters.Add("@.UserID", strUserID);
No comments:
Post a Comment