[ad_1] 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 [ad_2] solved SQL parameters not working
[ad_1] 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 … Read more