private void set_SupplierNameCombo()
{
//DataBase_A.Supliers cust = new DataBase_A.S();
Store.supliers sup = new Store.supliers();
// DataTable dt = sup.supplier_ID_List();
dt = sup.Supplier_ID_List();
for (int i = 0; i < dt.Rows.Count; i++)
{
SupplierNameComboBox.Items.Add(dt.Rows[i]["Name"]);
como_sup_in_show_sup.Items.Add(dt.Rows[i]["Name"]);
}
}
private void btnSalesName_Click(object sender, EventArgs e)
{
if (combosuppliername.Text != "")
{
DataTable dt = new Store.supliers().sales(combosuppliername.SelectedItem.ToString());
checkDataTable(dt);
}
else
{
MessageBox.Show("Please select the Supplier Name", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void setCombo()
{
combosuppliername.Items.Clear();
DataTable dt = new Store.supliers().Supplier_ID_List();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
combosuppliername.Items.Add(dt.Rows[i]["Name"]);
}
}
else
{
MessageBox.Show("Supplier names are not present", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btn_show_suplier_prod_Click(object sender, EventArgs e)
{
String a = como_sup_in_show_sup.Text;
if (a != null && a != "")
{
Store.supliers ss = new Store.supliers();
DataTable dd = ss.get_sup_prod(a);
if (dd != null)
{
DataGridView.DataSource = dd;
}
else
{
MessageBox.Show("No Product Available for Supplier " + a, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Please select a Supplier !", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
