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);
}
}
