What's wrong with my SQL statement?
I got an error message "No value given for one or more required parameters" when SQL statement is executed.
The SQL statement is following:
string strLocationSQL = "DELETE FROM Location ";
strLocationSQL += @"WHERE ((Project.ProjectID)=" +Convert.ToInt32(ProjectID)+ " AND ";
strLocationSQL += @"Location.LocationID = Project.LocationID) ";
Could you tell me how to fix it?
Thanks,
|