I keep getting an error,when i am trying to put an insert value within a select, but it won't work! here is a sample of my code:
sql = "INSERT INTO TblOrder (OrderID, BookID, CustomerID, OrderQty, OrderDate, TotalBefDisc) SELECT " + OrderIDBox.Text + "," + BookIDBox.Text + "," + CustBox.Text +...