hello,
I'm creating e-menu system for a restuarent... It has 3 users... and in staff user i want , when the staff see orders of the
custmer from StoreOrders1 table which will be displayed in DataGrideView ... i want a botton to move the records of StoreOrders1 to ReceiveOrder table..
and this the code that I tryed but I have error in it..
Imports System.Data.SqlClient
Imports System.IO
Imports System.Data
Imports System.Data.OleDb
Public Class Orders
Dim con As New SqlClient.SqlConnection()
Dim cmd As New SqlClient.SqlCommand()
Dim dataap As New SqlClient.SqlDataAdapter()
Dim ds As New DataSet()
Dim i, c As Integer
Dim dr As DataRow
Private strSQL As String = ""
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
MsgBox("Order has been Recived")
Dim strSQL As String = ""
con.Open()
strSQL = "select TableNo,FoodName, Quantity , Price INTO TableNo ,FoodName, Quantity , Price FROM StoreOrders4 WHERE TableNo = 4"
cmd = New SqlClient.SqlCommand(strSQL, con)
cmd.ExecuteNonQuery()
con.Close()
End Sub
End Class