Click here to Skip to main content
15,885,914 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionApplication Deployment Pin
jugnu_ad12-Dec-11 1:32
jugnu_ad12-Dec-11 1:32 
AnswerRe: Application Deployment Pin
Dave Kreskowiak12-Dec-11 8:34
mveDave Kreskowiak12-Dec-11 8:34 
AnswerRe: Application Deployment Pin
dr.kitanjal15-Dec-11 1:57
dr.kitanjal15-Dec-11 1:57 
QuestionArray not calculating correctly Pin
Member 847941811-Dec-11 11:25
Member 847941811-Dec-11 11:25 
AnswerRe: Array not calculating correctly Pin
Andy_L_J12-Dec-11 0:24
Andy_L_J12-Dec-11 0:24 
GeneralRe: Array not calculating correctly Pin
Member 847941812-Dec-11 8:39
Member 847941812-Dec-11 8:39 
AnswerRe: Array not calculating correctly Pin
Andy_L_J12-Dec-11 11:58
Andy_L_J12-Dec-11 11:58 
Questionsql query for filtering Access database by date Pin
Amanjot10-Dec-11 16:34
Amanjot10-Dec-11 16:34 
Hi,
I am trying to fill the gridview with the data from an Access table for a range of dates.

Dim cmd1 As String = "Select * from " & inpTable & " Where mdateTime = '29/09/2011'"
MsgBox("cmd= " & cmd1)
Dim da As OleDbDataAdapter
Try
    da = New OleDbDataAdapter(cmd1, myConnection)
Catch ex As Exception    ' Catch the error.
    MsgBox(ex.ToString)   ' Show friendly error message.
End Try

Try
    Dim table As New DataTable
    da.Fill(table)
    DataGridView1.DataSource = table
Catch ex As Exception
    MsgBox(ex.ToString)
End Try
myConnection.Close()


Command as it appears in the MsgBox
Select * from rawClimateData Where mdateTime > 30/09/2011 10:45:00 AM


The query works if I am not filtering the data base; however, with filter I get the syntax error "missing operator".

Any suggestion??
AnswerRe: sql query for filtering Access database by date Pin
JR21210-Dec-11 19:56
JR21210-Dec-11 19:56 
AnswerRe: sql query for filtering Access database by date Pin
Dave Kreskowiak11-Dec-11 3:27
mveDave Kreskowiak11-Dec-11 3:27 
AnswerRe: sql query for filtering Access database by date Pin
coded00711-Dec-11 21:35
professionalcoded00711-Dec-11 21:35 
QuestionVB.NET 2010, Form Close Question Pin
Framework .l.9-Dec-11 15:19
Framework .l.9-Dec-11 15:19 
AnswerRe: VB.NET 2010, Form Close Question Pin
Luc Pattyn9-Dec-11 15:34
sitebuilderLuc Pattyn9-Dec-11 15:34 
AnswerRe: VB.NET 2010, Form Close Question Pin
daveh604517-Jan-12 23:28
daveh604517-Jan-12 23:28 
QuestionConection lines without crossing other lines Pin
JR2128-Dec-11 2:20
JR2128-Dec-11 2:20 
AnswerRe: Conection lines without crossing other lines Pin
Luc Pattyn8-Dec-11 2:43
sitebuilderLuc Pattyn8-Dec-11 2:43 
QuestionTree view Pin
Member 84675328-Dec-11 0:46
Member 84675328-Dec-11 0:46 
AnswerRe: Tree view Pin
Simon_Whale8-Dec-11 0:56
Simon_Whale8-Dec-11 0:56 
QuestionConnection String for remote access database Pin
Vikash Yadav6-Dec-11 19:53
Vikash Yadav6-Dec-11 19:53 
AnswerRe: Connection String for remote access database Pin
DaveAuld6-Dec-11 20:13
professionalDaveAuld6-Dec-11 20:13 
GeneralRe: Connection String for remote access database Pin
Vikash Yadav6-Dec-11 20:39
Vikash Yadav6-Dec-11 20:39 
GeneralRe: Connection String for remote access database Pin
DaveAuld6-Dec-11 20:57
professionalDaveAuld6-Dec-11 20:57 
QuestionHow to copy a root directory (copy a flash drive) and paste it somewhere else? Pin
Brandon-X120006-Dec-11 15:33
Brandon-X120006-Dec-11 15:33 
AnswerRe: How to copy a root directory (copy a flash drive) and paste it somewhere else? Pin
Skynet_Code6-Dec-11 22:18
Skynet_Code6-Dec-11 22:18 
QuestionCode crashing on FindFirst Pin
Cynthia Quiroz4-Dec-11 13:15
Cynthia Quiroz4-Dec-11 13:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.