private void Button4_Click(object sender, System.EventArgs e) { cnnt sc = new cnnt(); sc.insqry = ("select * from " + (cmbdel.SelectedItem + " ")); sc.schfn(); Dgvsrch.DataSource = sc.stv; }
private void btnshw_Click(object sender, EventArgs e) { cnnt sc = new cnnt(); sc.insqry = ("select * from " + (Cmbup.SelectedItem + " ")); sc.schfn(); dgvu.DataSource = sc.stv; }
private void Button2_Click(object sender, System.EventArgs e) { cnnt sc = new cnnt(); sc.insqry = ("select * from " + (Cmbtbls.SelectedItem + (" where " + (cmbfld.Text + (" =\'" + (Txtsrch.Text + "\' ")))))); sc.schfn(); Dgvsrch.DataSource = sc.stv; }
private void Button1_Click(object sender, System.EventArgs e) { cnnt sc = new cnnt(); sc.insqry = ("select * from " + (Cmbup.SelectedItem + (" where " + (txtupid.Text + (" = \'" + (txtui.Text + "\' ")))))); sc.schfn(); dgvu.DataSource = sc.stv; }
private void BtnPrice_Click(object sender, System.EventArgs e) { var Frm = new FrmSUD(); Frm.Show(); Frm.Pnlup.Visible = false; cnnt sc = new cnnt(); sc.insqry = "SELECT * FROM `pricetbl`"; sc.schfn(); Frm.Dgvsrch.DataSource = sc.stv; }
private void BtnUninv_Click(object sender, System.EventArgs e) { var Frm = new FrmSUD(); Frm.Show(); Frm.Pnlup.Visible = false; cnnt sc = new cnnt(); sc.insqry = "SELECT * FROM `paymenttbl` WHERE Balance >\'0\' "; sc.schfn(); Frm.Dgvsrch.DataSource = sc.stv; }
private void SalesToolStripMenuItem_Click(object sender, EventArgs e) { var Frm = new FrmSUD(); Frm.Show(); Frm.Pnlup.Visible = false; cnnt sc = new cnnt(); sc.insqry = "SELECT * FROM `paymenttbl`"; sc.schfn(); Frm.Dgvsrch.DataSource = sc.stv; }
private void btnshw_Click(object sender, System.EventArgs e) { try { cnnt sc = new cnnt(); sc.cnntotbl(); sc.insqry = ("SELECT * FROM `paymenttbl` WHERE `Customer_Id` = \'" + (txtcusid.Text + "\' and `Balance` > \'0\'")); sc.schfn(); Dgb.DataSource = sc.stv; } catch (Exception ex) { MessageBox.Show(("Please check entered values " + ex.Message)); } }
private void Button2_Click(object sender, System.EventArgs e) { try { cnnt sc = new cnnt(); sc.insqry = ("UPDATE `paymenttbl` SET `Balance`\'" + (txtpbnc.Text + ("\', `Paid` = \'" + (txtttp.Text + ("\' where `Bill_Id` = \'" + (TxtBnum.Text + "\'")))))); sc.cnntotbl(); sc.insqry = ("SELECT * FROM `paymenttbl` WHERE `Customer_Id` = \'" + (txtcusid.Text + "\' and `Balance` > \'0\'")); sc.schfn(); Dgb.DataSource = sc.stv; } catch (Exception ex) { MessageBox.Show(("Please check entered values " + ex.Message)); } }
private void btnsearch_Click(object sender, EventArgs e) { try { { cnnt sc = new cnnt(); sc.insqry = ("select * from insert where productID='" + (productID.Text + "' ")); sc.schfn(); dataGridView1.DataSource = sc.stv; } } catch (Exception ex) { MessageBox.Show("" + ex); } }