private void txtBarcode_TextChanged(object sender, EventArgs e) { try { DataSet current = new DataSet(); //cn.da = new System.Data.SqlClient.SqlDataAdapter("Select *from sell_check_Product where Barcode='"+txtBarcode.Text+"'",cn.cn); //cn.da.Fill(current); current = cntrl_sell.check_Barcode(txtBarcode.Text); if (current.Tables[0].Rows.Count > 0) { String id = current.Tables[0].Rows[0]["ProductID"].ToString(); String proname = current.Tables[0].Rows[0]["ProductName"].ToString(); String category = current.Tables[0].Rows[0]["ProductTypeName"].ToString(); decimal Price = Convert.ToDecimal(current.Tables[0].Rows[0]["Sell"]); int qty = 0; qty = Convert.ToInt32(current.Tables[0].Rows[0]["Qty"].ToString()); String Unit = current.Tables[0].Rows[0]["UnitName"].ToString(); if (qty <= 1) { MessageBox.Show("product is 0"); return; } for (int sr = 0; sr < dgvProductsList.Rows.Count; sr++) { if (id == dgvProductsList.Rows[sr].Cells[1].Value.ToString()) { ms.Check_DataSameProduct(); return; } } dgvProductsList.Rows.Add("", id, proname, category, Price, "1", Unit); txtCount.Text = dgvProductsList.Rows.Count.ToString(); foreach (DataGridViewRow r in dgvProductsList.Rows) { int n = r.Index; dgvProductsList.Rows[n].Cells[7].Value = double.Parse(dgvProductsList.Rows[n].Cells[4].Value.ToString()) * double.Parse(dgvProductsList.Rows[n].Cells[5].Value.ToString()); double PricePro = 0, Result = 0; foreach (DataGridViewRow cr in dgvProductsList.Rows) { PricePro = Convert.ToDouble(cr.Cells[7].Value); Result = Result + PricePro; txtSumPrice.Text = Result.ToString("#,###"); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }