//Get DB data and push to Datasource void LoadDB() { DSource = DBCall.GetTest(); DGVTest.DataSource = null; DGVTest.DataSource = DSource; DGVTest.Columns[0].ReadOnly = true; }
//Check input and test connection private void BLogin_Click(object sender, EventArgs e) { if (Err.IsAllDigits(TBPort.Text)) { DBCall.InitMySQL(TBIP.Text, Convert.ToUInt32(TBPort.Text), TBUser.Text, TBPass.Text, TBDB.Text); if (DBCall.logres) { loggedin = true; Close(); } } }
//Send data to datasource private void BSubmit_Click(object sender, EventArgs e) { if (TBDKP.Text != null && TBDKP.Text != "" && Err.IsAllDigits(TBDKP.Text) && TBDKP.Text != DGVTest.SelectedRows[0].Cells[2].Value.ToString()) { int tableval = Convert.ToInt32(DGVTest.SelectedRows[0].Cells[2].Value); if (RBAdd.Checked) { tableval += Convert.ToInt32(TBDKP.Text); DGVTest.SelectedRows[0].Cells[2].Value = tableval; } if (RBEdit.Checked) { DGVTest.SelectedRows[0].Cells[2].Value = Convert.ToInt32(TBDKP.Text); } if (RBSubtract.Checked) { tableval -= Convert.ToInt32(TBDKP.Text); DGVTest.SelectedRows[0].Cells[2].Value = tableval; } RefreshDB(); DSend = GetChanges(); DBCall.SetData(); FuncDisable(); } else if (TBDKP.Text == DGVTest.SelectedRows[0].Cells[2].Value.ToString()) { FuncDisable(); } //Verify input value else if (!Err.IsAllDigits(TBDKP.Text) && TBDKP.Text != null && TBDKP.Text != "") { MessageBox.Show("You can only use nubers.", "Input Error"); } else if (TBDKP.Text == null || TBDKP.Text == "") { MessageBox.Show("Input cannot be blank", "Input Error"); } }