private void FormClients_Load(object sender, EventArgs e) { dsHiTech.Tables.Add(dtClients); dsHiTech = UtilityDBDisconnected.GetDataSetClients(dsHiTech, dtClients); dataGridViewClient.DataSource = dsHiTech; dataGridViewClient.DataMember = "Clients"; }
private void buttonupdatedatabase_Click(object sender, EventArgs e) { if (dsHiTech.HasChanges()) { sqlDa = UtilityDBDisconnected.GetDataAdapterClients(); sqlCmdClient = new SqlCommandBuilder(sqlDa); sqlDa.Update(dsHiTech.Tables["Clients"]); MessageBox.Show("Database has been updated successfully.", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void buttonList_Click(object sender, EventArgs e) { dsHiTech = UtilityDBDisconnected.GetDataSetClients(dsHiTech, dtClients); dataGridViewClient.DataSource = dsHiTech; dataGridViewClient.DataMember = "Clients"; }