private void Replace_Click(object sender, EventArgs e)
{// Удаление записи о выдаче диска в БД
string sql = "DELETE DVD WHERE ID_Name = (" + SELECT.WhereValue("Name", Result.CurrentRow.Cells[0].Value.ToString()) +
") AND ID_Contact = (" + SELECT.WhereValue("Contact", Title.Text) + ")";
SqlCommand command = new SqlCommand(sql, connection);
command.ExecuteNonQuery();
}
private void ButtonSearch_Click(object sender, EventArgs e)
{// Поиск по названию в БД
string sql = SELECT.WhereValue("NameField", TextBoxSearch.Text);
SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
adapter.Fill(ds);
Result.DataSource = ds.Tables[0];
}
