31-01-21, 01:25 AM
(آخر تعديل لهذه المشاركة : 31-01-21, 01:43 AM {2} بواسطة عاصم النجار.)
PHP كود :
'(@transno nvarchar(12),@pid nvarchar(1),@price float,@pdate nvar' expects the parameter '@usser', which was not supplied
دي رسالة الخطأ
كود الحفظ
PHP كود :
If e.KeyCode = Keys.Escape Then
Me.Dispose()
ElseIf e.KeyCode = Keys.Enter Then
cn.Open()
cm = New SqlCommand("Insert into TblCart (transno,pid,price,pdate,tableno,qty,usser) Values (@transno,@pid,@price,@pdate,@tableno,@qty,@usser)", cn)
With cm
.Parameters.AddWithValue("@transno", Frm_POS.lblTransNo.Text)
.Parameters.AddWithValue("@pid", id)
.Parameters.AddWithValue("@price", price)
.Parameters.AddWithValue("@pdate", sdate)
.Parameters.AddWithValue("@tableno", Frm_POS.lblTableNo.Text)
.Parameters.AddWithValue("@qty", CDbl(txtQty.Text))
.Parameters.AddWithValue("@usser", str_user)
.ExecuteNonQuery()
End With
cn.Close()
'***********************
cn.Open()
cm = New SqlCommand("update TblCart set total = price * qty ", cn)
cm.ExecuteNonQuery()
cn.Close()
Frm_POS.LoadCart()
Me.Dispose()
End If
تم حل المشكلة بفضل الله