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
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