Hi everyone I have the folowing code in the Business class in my program, but when i run it says that there's an error in the sql. Can you please help Public Function AddSale(ByVal dtDate As DateTime, ByVal bookcode As String, ByVal InvoiceNo As String, ByVal qty As Integer, ByVal subtot As Single, ByVal vat As Single, ByVal tot As Single) As String Dim sql As String Dim cmd As OleDb.OleDbCommand Dim result As String = "" Try sql = "INSERT INTO SALES (Dates, BookCode, InvoiceNumber, Quantity, SubTotal, VAT, Total) Values ( " + dtDate + " ,'" + bookcode + "','" + InvoiceNo + "', qty , subtot, vat, tot)" cmd = New OleDb.OleDbCommand(sql, con) cmd.Parameters.Add(New OleDb.OleDbParameter("@qty", qty)) cmd.Parameters.Add(New OleDb.OleDbParameter("@subtot", subtot)) cmd.Parameters.Add(New OleDb.OleDbParameter("@vat", vat)) cmd.Parameters.Add(New OleDb.OleDbParameter("@tot", tot)) cmd.Parameters.Add(New OleDb.OleDbParameter("@dtDate", dtDate)) If cmd.Connection.State = ConnectionState.Closed Then cmd.Connection.Open() End If cmd.CommandText = sql cmd.ExecuteNonQuery() result = "true" Catch ex As Exception result = ex.Message.ToString() End Try Return result End Function

Hello Everyone I'm using VB. Net, can you tell me how to display records in a datagrid in a Date range. I have 2 DataAdapters, the other one has parameters "Date" and one DateTimePicker.

Hi everyone Im using VB.Net 2003. I have a field in a datagrid "Total", how do i calculate the total:sigh: and Display it in a label