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);
}
}
