private async void buttonX3_Click(object sender, EventArgs e) { buttonX3.Enabled = false; SqlInfor = new SqlCommand(); for (int i = 0; i < Sqlcom.Parameters.Count; i++) { for (int j = 0; j < SqlInfor.Parameters.Count; j++) { if (SqlInfor.Parameters[j].ParameterName == Sqlcom.Parameters[i].ParameterName) { goto Up; } } SqlInfor.Parameters.Add(new System.Data.SqlClient.SqlParameter(Sqlcom.Parameters[i].ParameterName, Sqlcom.Parameters[i].Value)); goto End; Up: SqlInfor.Parameters.Add(new System.Data.SqlClient.SqlParameter(Sqlcom.Parameters[i].ParameterName + "1", Sqlcom.Parameters[i].Value)); End: ; } dataGridViewX1.Rows.Clear(); await Sqldatabasethrding.WaitSqlsersh(textBoxX1.Text, SerchAdvaCours, idJop, idTema, checkBoxX1.Checked, information, SqlInfor, dataGridViewX1, dateTimeInput1.Value, dateTimeInput2.Value); buttonX3.Enabled = true; }
private void buttonX1_Click(object sender, EventArgs e) { Int64 NUmber = 0; if (textBoxForInationlNumber1.Text != "") { NUmber = Convert.ToInt64(textBoxForInationlNumber1.Text); } Sqldatabasethrding.WaitSqlsersh(comboBoxEx1.Text, NUmber, idVitel1.Text, dateTimeInput2.Value, dateTimeInput1.Value, progressBarX1, dataGridViewX1); }