Hi,
my item is not getting add into datagrid view when i press the add button.its giving me message "This Much Value is not available"
but my opening quantity in Item table is 10 as i am entering item Laptop.
private void addButton_Click(object sender, EventArgs e)
{
//First we need to check stock if stock available,if not we will give message
int stock = 0;
SqlCommand cmd1 = con.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select * from Item where ItemName = '"+ itemNameValue +"'";
cmd1.ExecuteNonQuery();
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dt1);
foreach (DataRow dr1 in dt1.Rows)
{
stock = Convert.ToInt32(dr1["OpeningQuantity"].ToString());
}
if (Convert.ToUInt32(qtyValue.Text)>stock)
{
MessageBox.Show("This Much Value is not available");
}
else
{
DataRow dr = dt.NewRow();
dr["ItemName"] = itemNameValue.Text;
dr["Rate"] = salePrice.Text;
dr["Qty"] = qtyValue.Text;
dr["Amount"] = amountValue.Text;
dt.Rows.Add(dr);
dataGridView.DataSource = dt;
tot = tot + Convert.ToInt32(dr["total"].ToString());
totallabelvalue.Text = tot.ToString();
}
}
}
Laxmidhar SahooPosted Nov 27, 2018, 9:37 PM
Tayyab JatoiPosted Dec 1, 2018, 11:36 PM
Rizwan AhmedPosted Nov 28, 2018, 11:54 AM
Tayyab JatoiPosted Nov 26, 2018, 11:09 PM
Laxmidhar SahooPosted Nov 26, 2018, 9:48 PM