public Accounting() { this.StartPosition = FormStartPosition.CenterScreen; mysqlConn = new customerDbConn(); mysqlConn.connect(); InitializeComponent(); if (mysqlConn.connOpen() == true) { dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `orderdetails`").Tables[0]; dataGridView2.DataSource = mysqlConn.qry("SELECT * FROM `products`").Tables[0]; } mysqlConn.connClose(); }
public Ticket() { this.StartPosition = FormStartPosition.CenterScreen; InitializeComponent(); mysqlConn = new customerDbConn(); mysqlConn.connect(); if (mysqlConn.connOpen() == true) { dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `poll_main`").Tables[0]; dataGridView2.DataSource = mysqlConn.qry("SELECT * FROM `poll_options`").Tables[0]; dataGridView3.DataSource = mysqlConn.qry("SELECT * FROM `poll_votes`").Tables[0]; } mysqlConn.connClose(); }
public Profit() { this.StartPosition = FormStartPosition.CenterScreen; mysqlConn = new customerDbConn(); mysqlConn.connect(); InitializeComponent(); if (mysqlConn.connOpen() == true) { dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `sales`").Tables[0]; dataGridView2.DataSource = mysqlConn.qry("SELECT * FROM `orderdetails`").Tables[0]; dataGridView3.DataSource = mysqlConn.qry("SELECT * FROM `tblCustomer`").Tables[0]; dataGridView4.DataSource = mysqlConn.qry("SELECT * FROM `products`").Tables[0]; itemsSold.Text = "0"; } mysqlConn.connClose(); }
public CRM() { this.StartPosition = FormStartPosition.CenterScreen; InitializeComponent(); mysqlConn = new customerDbConn(); mysqlConn.connect(); if (mysqlConn.connOpen() == true) { dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblCustomer`").Tables[0]; } mysqlConn.connClose(); }
private void Add_Click(object sender, EventArgs e) { string errorMsg; if (!ValidFirstName(FirstName.Text, out errorMsg)) { // Cancel the event and select the text to be corrected by the user. // Set the ErrorProvider error with the text to display. Alert.Show(errorMsg); } if (!ValidLastName(LastName.Text, out errorMsg)) { // Cancel the event and select the text to be corrected by the user. // Set the ErrorProvider error with the text to display. Alert.Show(errorMsg); } else if (!ValidEmailAddress(Email.Text, out errorMsg)) { // Set the ErrorProvider error with the text to display. Alert.Show(errorMsg); } else { if (mysqlConn.connOpen() == true) { var Name = LastName.Text + " " + FirstName.Text; mysqlConn.insertCustomer(Name, FirstName.Text, LastName.Text, TelNum.Text, address.Text, city.Text, Email.Text, country.Text); dataGridView1.DataSource = mysqlConn.qry("SELECT * FROM `tblCustomer`").Tables[0]; Name = ""; } } }