Hi,
I have a table Role in sql database wih following fields
RoleID pk int
Description nvarchar(50)
I am trying to run a parameterised query using sqlcommand and exceutenonquery using following code but it is giving error
"Incorrect syntax near ' '.\r\nIncorrect syntax near ' ":
------------------------------------------------------------------------------------------------------------------------------
SqlConnection objConn = new SqlConnection("Data Source=HDDLNTD6011180;Initial Catalog=TestDal;Integrated Security=True");
objConn.Open();
System.Data. IDbCommand cmd = new SqlCommand("UPDATE [Role] SET [Description] = WHERE [RoleID] = ",objConn);
IDataParameterCollection cmdParams = cmd.Parameters;
System.Data. IDbDataParameter parDescription = cmd.CreateParameter();
parDescription.ParameterName = " ";
parDescription.Value = "testing";
cmdParams.Add(parDescription);
System.Data. IDbDataParameter checkRoleID = cmd.CreateParameter();
checkRoleID.ParameterName = " ";
checkRoleID.Value = 15; //any test value which is present in database
cmdParams.Add(checkRoleID);
cmd.ExecuteNonQuery();
-----------------------------------------------------------------------------------------
I don't see any fault at my end.Please let me know how to resolve this issue.
regards
.NET Development11
|