Reply to thread

Message

<blockquote data-quote="Moordoom" data-source="post: 164573" data-attributes="member: 48852">I am trying to do an SQL Select Query by using the dates supplied by two DateTimePickers to export data from a SQL Server to an Excel Spreadsheet.When I run the app, I get &quot;Line1: Incorrect syntax near 'Tuesday, November 12, 2013 AND Wednesday, November 13, 2013'. &quot;The query is being run on an SQL 2000 server, and the DateTime Format on the server is MM/dd/yyyy hh:mm:ss tt in the record.I have tried doing a DateTimePickerFormat[CODE]&nbsp; &nbsp; &nbsp; &nbsp; DateTimePicker1.Format = DateTimePickerFormat.CustomDateTimePicker1.CustomFormat = &quot;MM/d/yyyy hh:mm:ss tt&quot;DateTimePicker2.Format = DateTimePickerFormat.CustomDateTimePicker2.CustomFormat = &quot;MM/d/yyyy hh:mm:ss tt&quot;[/CODE]Which gives the same error in 11/12/2013 02:00:00 PM 11/13/2013 02:00:00 PMI have Tried[CODE]DatePicker1.Format = DateTimePickerFormat.CustomDateTimePicker1.CustomFormat = &quot;MM/d/yyyy&quot;DateTimePicker2.Format = DateTimePickerFormat.CustomDateTimePicker2.CustomFormat = &quot;MM/d/yyyy&quot;[/CODE]Which gives the same error in 11/12/2013 AND 11/13/2013Here is my current Select code...[CODE]Dim dataAdapter As New SqlClient.SqlDataAdapter()Dim dataSet As New DataSetDim command As New SqlClient.SqlCommandDim datatableMain As New System.Data.DataTable()Dim connection As New SqlClient.SqlConnectionDateTimePicker1.Format = DateTimePickerFormat.CustomDateTimePicker1.CustomFormat = &quot;MM/d/yyyy&quot;DateTimePicker2.Format = DateTimePickerFormat.CustomDateTimePicker2.CustomFormat = &quot;MM/d/yyyy&quot;Dim dt1 As String = DateTimePicker1.TextDim dt2 As String = DateTimePicker2.Textconnection.ConnectionString = &quot;Data Source=SQL01_2000;database=App_DB;uid=sa;pwd=sa&quot;command.Connection = connectioncommand.CommandType = CommandType.Textcommand.CommandText = &quot;Select * from LabelCheck WHERE [Date1] BETWEEN '&quot; &amp; dt1 &amp; &quot; AND &quot; &amp; dt2 &amp; &quot;'&quot;dataAdapter.SelectCommand = command[/CODE]What am I missing?I put this in the Forms Forum, but it may belong in the SQL one.</blockquote>

[QUOTE="Moordoom, post: 164573, member: 48852"] I am trying to do an SQL Select Query by using the dates supplied by two DateTimePickers to export data from a SQL Server to an Excel Spreadsheet. When I run the app, I get "Line1: Incorrect syntax near 'Tuesday, November 12, 2013 AND Wednesday, November 13, 2013'. " The query is being run on an SQL 2000 server, and the DateTime Format on the server is MM/dd/yyyy hh:mm:ss tt in the record. I have tried doing a DateTimePickerFormat [CODE] DateTimePicker1.Format = DateTimePickerFormat.Custom DateTimePicker1.CustomFormat = "MM/d/yyyy hh:mm:ss tt" DateTimePicker2.Format = DateTimePickerFormat.Custom DateTimePicker2.CustomFormat = "MM/d/yyyy hh:mm:ss tt" [/CODE] Which gives the same error in 11/12/2013 02:00:00 PM 11/13/2013 02:00:00 PM I have Tried [CODE] DatePicker1.Format = DateTimePickerFormat.Custom DateTimePicker1.CustomFormat = "MM/d/yyyy" DateTimePicker2.Format = DateTimePickerFormat.Custom DateTimePicker2.CustomFormat = "MM/d/yyyy" [/CODE] Which gives the same error in 11/12/2013 AND 11/13/2013 Here is my current Select code... [CODE] Dim dataAdapter As New SqlClient.SqlDataAdapter() Dim dataSet As New DataSet Dim command As New SqlClient.SqlCommand Dim datatableMain As New System.Data.DataTable() Dim connection As New SqlClient.SqlConnection DateTimePicker1.Format = DateTimePickerFormat.Custom DateTimePicker1.CustomFormat = "MM/d/yyyy" DateTimePicker2.Format = DateTimePickerFormat.Custom DateTimePicker2.CustomFormat = "MM/d/yyyy" Dim dt1 As String = DateTimePicker1.Text Dim dt2 As String = DateTimePicker2.Text connection.ConnectionString = "Data Source=SQL01_2000;database=App_DB;uid=sa;pwd=sa" command.Connection = connection command.CommandType = CommandType.Text command.CommandText = "Select * from LabelCheck WHERE [Date1] BETWEEN '" & dt1 & " AND " & dt2 & "'" dataAdapter.SelectCommand = command [/CODE] What am I missing? I put this in the Forms Forum, but it may belong in the SQL one. [/QUOTE]

Verification