Hello Team,
am using textbox to scan barcode but when I enter the barcode it return this error Incorrect syntax near '202406273, I tried severall ways to debbug it but no avail.
private void frmQty_KeyPress(object sender, KeyPressEventArgs e) { if ((e.KeyChar == 13) && (txtQty.Text != String.Empty)) { bool found = false;
string sdate = DateTime.Now.ToString("yyyyMMdd"); cn.Open() cm = new SqlCommand("select Invoice from tblCart where Invoice like @date order by CartId desc", cn); cm.Parameters.AddWithValue("@date", "%" + sdate + "%"); cm.Parameters.AddWithValue("@Invoice", fSales.lblIvoiceNo.Text); dr = cm.ExecuteReader(); dr.Read(); if (dr.HasRows) { found = true; //id = dr["CartId"].ToString(); //cart_qty = int.Parse(dr["Qty"].ToString()); dr.Close();
} else { found = false; } dr.Close(); cn.Close();
if (found == true) {
fSales.txt_Search.Clear(); fSales.txt_Search.Focus(); fSales.LoadCart(); this.Dispose(); } else { // validate product quantity to show avoid selling when product is out of stock if (txtQty.Text == String.Empty) { cn.Close(); return; }
cn.Open(); cm = new SqlCommand("insert into tblCart (Invoice, ProductId, Price, Qty, Sdate)values(@Invoice, @ProductId, @Price, @Qty, @Sdate)", cn); cm.Parameters.AddWithValue("@Invoice", fSales.lblIvoiceNo.Text); cm.Parameters.AddWithValue("@ProductId", lblPID.Text); cm.Parameters.AddWithValue("@price", lblPrice.Text); cm.Parameters.AddWithValue("@qty", int.Parse(txtQty.Text)); cm.Parameters.AddWithValue("@sdate", fSales.dtTransactionDate.Value); // cm.Parameters.AddWithValue("@cashier", fSales.lblUser.Text); cm.ExecuteNonQuery(); cn.Close(); MessageBox.Show("Product quatity has been successfully added", stitle, MessageBoxButtons.OK, MessageBoxIcon.Information); fSales.txt_Search.Clear(); fSales.txt_Search.Focus(); fSales.LoadCart();
this.Dispose(); }
}