public void TestRefresh(frmVendors theForm) { this.clearDataGrid(); VendorDB.PullVendorsFromDB(); populateDateGrid(); }
public frmVendors() { InitializeComponent(); clearDataGrid(); VendorDB.PullVendorsFromDB(); InitTimer(); populateDateGrid(); comboVendorSearchTypes.Items.Clear(); comboVendorSearchTypes.Items.Add("ID"); comboVendorSearchTypes.Items.Add("Name"); }
private void btnVendorDelete_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete this record?", "ATTENTION: PERMANENT CHANGE", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { Console.WriteLine("Yes"); VendorIDSelected = Int32.Parse(dataGridVendors.CurrentRow.Cells[0].Value.ToString()); string deleteStatement = "delete from Vendors where VendorID='" + VendorIDSelected + "'"; SqlConnection connection = new SqlConnection(VendorDB.connectionString); SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); try { connection.Open(); deleteCommand.ExecuteNonQuery(); MessageBox.Show("Record deleted. "); clearDataGrid(); VendorDB.PullVendorsFromDB(); populateDateGrid(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } } else if (dialogResult == DialogResult.No) { // } }
public void reloadDefaultData() { clearDataGrid(); VendorDB.PullVendorsFromDB(); populateDateGrid(); }