Visual Basic

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDesktop ProgrammingVisual Basic

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old January 23rd, 2013, 06:03 AM
bleeding_me bleeding_me is offline
Registered User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Jan 2013
Posts: 1 bleeding_me User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 m 15 sec
Reputation Power: 0
Visual Basic & Database SQL Search

I am creating a small desktop application with connection to a Access Database.

I created the database in MS Access 2010.

I have a table BSKT_GAME with a key field (Game_date) with Date/Time. What I am trying to do is a SELECT to that table (in Visual Basic 2012) to retrieve records where the field Game_date is greater or equal to 11 January 2013.

This date is stored in a DateTimePicker Control.

First, to see the SQL statement, I created a Query in Ms Access, and it is as follows:
Code:
SELECT * FROM BSKT_GAME WHERE (((BSKT_GAME.Game_Date)>=#1/11/2013#));


and in MsAccess this works fine, the records shown are the correct ones.

My problem is when I put the code into VB2012:
Code:
Dim Sql as string
Dim dsGrid as new Dataset
Dim daGrid as new OleDb.OleDBDataAdapter

sql = "SELECT * FROM BSKT_GAME WHERE BSKT_GAME.Game_date >=#" & datetimepicker.value & "#;"

daGrid = New OleDb.OleDbDataAdapter(sql, Connection)
daGrid.Fill(dsGrid, "SelectWhere")

MsgBox(dsGrid.Tables("SelectWhere").Rows.Count)


and in the MsgBox the value is 0, which is not correct.

One thing i noticed in Debug is that the datetimepicker.value appears as #1/11/2013# when i add a whatch, but when passed to the SQL it is transformed into #11-01-2013# .

Can anyone help me please ?

Reply With Quote
Reply

Viewing: Tutorialized ForumsDesktop ProgrammingVisual Basic > Visual Basic & Database SQL Search


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap