Cant Add item in sale cart

Question

 

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

}

}

}