[Solved] SQL parameters not working

You’re not actually running the command. You need to call ExecuteNonQuery or ExecuteScalar: using (var cmd = new SqlCommand(query, conDataBase)) { // set parameters… cmd.ExecuteNonQuery(); } 1 solved SQL parameters not working

[Solved] An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?

You should either use this method: SqlCommand cmd = new SqlCommand(“dbo.workScheduleDataGrid”, sqlcon); or this method SqlCommand cmd = sqlcon.CreateCommand(); to create the command, but not both (the second assignment in your code overwrites the first one). With the second options, you need to specify the command to execute separarely: cmd.CommandText = “dbo.workScheduleDataGrid”; Also, do not … Read more