public void datagridviewload()
{
try
{
DataTable dt = blbar.get_all_item_barcode();
if (dt.Rows.Count > 0)
{
dataGridView1.Rows.Clear();
for (int i = 0; dt.Rows.Count > i; i++)
{
int abc = dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells["cal_sn"].Value = i + 1;
dataGridView1.Rows[i].Cells["cal_product_id"].Value = dt.Rows[i]["product_id"].ToString();
int product_id = Convert.ToInt32(dataGridView1.Rows[i].Cells["cal_product_id"].Value);
DataTable dt_product_id = blpur.getallproductid(product_id);
dataGridView1.Rows[i].Cells["cal_product_name"].Value = dt_product_id.Rows[0]["product_name"].ToString();
dataGridView1.Rows[i].Cells["calitem_id"].Value = dt.Rows[i]["item_id"].ToString();
int item_id = Convert.ToInt32(dataGridView1.Rows[i].Cells["calitem_id"].Value);
DataTable dt_item_name = blod.getallitemprice(item_id);
dataGridView1.Rows[i].Cells["calitem_name"].Value = dt_item_name.Rows[0]["item_name"].ToString();
dataGridView1.Rows[i].Cells["cal_bar_code"].Value = dt.Rows[i]["bar_code"].ToString();
dataGridView1.Rows[i].Cells["cal_bar_code_id"].Value = dt.Rows[i]["bar_code_id"].ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cboitem_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboitem.SelectedIndex != 0)
{
DataTable dt = blord.getallitemprice(Convert.ToInt32(cboitem.SelectedValue.ToString()));
if (dt.Rows.Count > 0)
{
txtcost.Text = dt.Rows[0]["item_price"].ToString();
txtquantity.Focus();
}
}
}
