private void saveCustomer(string text) { try { Con.Open(); string qText = text; OleDbCommand Com = new OleDbCommand(); Com.Parameters.AddWithValue("@fio", tbFIO.Text); Com.Parameters.AddWithValue("@birth", Convert.ToDateTime(dtDateOfBirth.Text)); Com.Parameters.AddWithValue("@passNum", tbPassportNo.Text); Com.Parameters.AddWithValue("@dateOfl", Convert.ToDateTime(dtDateOfIssue.Text)); Com.Parameters.AddWithValue("@auth", tbAuthority.Text); Com.Parameters.AddWithValue("@adress", tbAddress.Text); Com.Parameters.AddWithValue("@phone", Convert.ToInt32(tbPhoneNumber.Text)); Com.CommandText = qText; Com.Connection = Con; Com.ExecuteNonQuery(); sprCustomerList sprCustomerList = new sprCustomerList(); sprCustomerList.loadCustomers(); this.Close(); } catch (Exception err) { MessageBox.Show(err.Message); } finally { Con.Close(); } }
private void button1_Click(object sender, EventArgs e) { sprCustomerList sprCustomerListForm = new sprCustomerList(); sprCustomerListForm.ModeCheck = "1"; sprCustomerListForm.Owner = this; sprCustomerListForm.ShowDialog(); }
private void клиентыToolStripMenuItem_Click(object sender, EventArgs e) { sprCustomerList sprCustomerList = new sprCustomerList(); sprCustomerList.Show(); }