private void btAllTable_Click(object sender, EventArgs e)
{
FormTable FormTable = new FormTable();
FormTable.ReadData();
FormTable.Show();
}
private void btSearch_Click(object sender, EventArgs e)
{
if ((tbName.Text == "") & (tbFam.Text == "") & (tbGroup.Text == "") & (tbCourse.Text == ""))
{
MessageBox.Show("Заполните хотя бы одно из полей!");
}
else
{
FormTable FormTable = new FormTable();
SqlConnection connection = new SqlConnection("Data Source=LENOVO-PC\\SQLEXPRESS;Initial Catalog=students;Integrated Security=True;Pooling=false");
connection.Open();
SqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT * FROM students WHERE Имя='" + tbName.Text + "'; SELECT * FROM students WHERE Фамилия='" + tbFam.Text + "'; SELECT * FROM students WHERE Группа='" + tbGroup.Text + "'; SELECT * FROM students WHERE Курс='" + tbCourse.Text + "' ";
SqlDataReader reader = command.ExecuteReader();
do // цикл просмотра результатов
{
while (reader.Read()) // цикл просмотра данных
{
ListViewItem item = FormTable.listView1.Items.Add(reader.GetValue(1).ToString());
item.SubItems.Add(reader.GetValue(2).ToString());
item.SubItems.Add(reader.GetValue(3).ToString());
item.SubItems.Add(reader.GetValue(4).ToString());
}
} while (reader.NextResult());
connection.Close();
FormTable.Show();
}
}
