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