Can someone give me an example of any related issues regarding with my problem. I cannot Update my tables using vb in vs 2010to access 2010. I use the code :
x = Val(txtProductID.Text)
MyDB.UpdtS("UPDATE Products SET ProductName='" & txtProductName.Text & "',Price='" & txtPrice.Text & "',Description='" & txtdesc.Text & "' WHERE ProductID='" & x & "'")
MessageBox.Show("Product has been Updated!")
I have a class name MyDB:
Public Shared Function UpdtS(ByVal qry As String) As Boolean
Dim cmd As New OleDbCommand
cmd.Connection = Connect
cmd.CommandText = qry
Try
cmd.ExecuteNonQuery()
Return True
Catch ex As Exception
Return False
End Try
End Function
and another thing, i have also a problem in my print out. i need a code for the printing my reciept!
)Thank you for reading and please reply.
)