private void buttonOK_Click(object sender, EventArgs e) { try { string query = "SELECT * FROM [Розклад тренера] WHERE "; int v = 0; if (comboBox1.Text != "") { query += " [День тижня] LIKE N'" + comboBox1.Text + "' AND "; } if (Int32.TryParse(textBox1.Text, out v)) { query += " [ID_тренера] >=" + textBox1.Text + " AND "; } if (Int32.TryParse(textBox2.Text, out v)) { query += " [ID_тренера] <=" + textBox2.Text + " AND "; } SqlConnection sqlconn = new SqlConnection(sqlConnectionString); SqlDataAdapter sda = new SqlDataAdapter(query.Substring(0, query.Length - 4), sqlconn); DataTable dt = new DataTable(); sda.Fill(dt); clientPage.dataGridView1.DataSource = dt; IsButton.Invoke(this, EventArgs.Empty); Close(); } catch (ArgumentOutOfRangeException t) { Console.WriteLine(t); } }
private void buttonOK_Click(object sender, EventArgs e) { try { string query = "SELECT * FROM Абонемент WHERE "; if (comboBox1.Text != "") { query += " [Вид занять] LIKE N'" + comboBox1.Text + "' AND "; } SqlConnection sqlconn = new SqlConnection(sqlConnectionString); SqlDataAdapter sda = new SqlDataAdapter(query.Substring(0, query.Length - 4), sqlconn); DataTable dt = new DataTable(); sda.Fill(dt); clientPage.dataGridView1.DataSource = dt; IsButton.Invoke(this, EventArgs.Empty); Close(); } catch (ArgumentOutOfRangeException t) { Console.WriteLine(t); } }