How can I set the sqldatasource parameter's value?
I'm trying to set the value of the sqldatasource's selectcommand parameter @ClientID as in the code below, but it's not working out.
My code:
Dim strCommand = "SELECT caller_id, phone, name, email FROM callers WHERE client_id=@ClientID"
SqlDataSource2.SelectCommand = strCommand
SqlDataSource2.SelectParameters.Add("@ClientID", iClientID)
What am I doing wrong?
Answer
The trick to make it work is to remove the paremeter you are trying to use before adding it. The following adapted version of your code should work:
' NOTE that there is no "@" sign when you use your parameters in the code
Parameter p = strCommandSqlDataSource2.SelectParameters["ClientID"]
strCommandSqlDataSource2.SelectParameters.Remove(p)
strCommandSqlDataSource2.SelectParameters.Add("ClientID", iClientID)
You should not use "@" sign when naming parameters in the code portion of its usage. You should use it only in the SQLCOMMAND string.
Hope it helps.