Posted on: 9/19/2014 8:27:52 AM | Views : 376

Hi 
In my application i have srchuserTxtBox were i write UID "FK" to show his info in a gridview, and in same page i have a dropdown to add a value for the UID which i write it in the srchuserTxtBox in one column in the table called VIP which accept "Yes or No" from dropdownlist . There  error message:   Error: Sys.WebForms.PageRequestManagerServerErrorException: Incorrect syntax near '('.

protected void Updusradmbtn_Click(object sender, EventArgs e) { SqlConnection USRVIPCON = new SqlConnection(sc); SqlCommand USRVIPcmd = new SqlCommand(); string sqlstatment = "UPDATE UserInfo (UID, VIP, VIPSince) VALUES (@USER,@VIP,@VIPDATE)"; USRVIPcmd.Connection = USRVIPCON; USRVIPcmd.CommandType = CommandType.Text; USRVIPcmd.CommandText = sqlstatment; //Insert the parameters firs ...

Go to the complete details ...