2 Replies - 1336 Views - Last Post: 11 March 2009 - 01:39 PM Rate Topic: -----

#1 baz86  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 11-March 09

Parameterised query for sql ce

Post icon  Posted 11 March 2009 - 10:30 AM

Hi all,

i am creating a pda application using vb.net and sqlce and i can't seem to get parameterised query (or atleast i think mine is one) working.

i dont know what i am missing because on the code below, i still get a END OF STATEMENT EXPECTED

please help





Dim strSQL As String = "select * from tblHoles WHERE (CourseID = '"&TextBox1.Text&"')"


Is This A Good Question/Topic? 0
  • +

Replies To: Parameterised query for sql ce

#2 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 418
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: Parameterised query for sql ce

Posted 11 March 2009 - 11:43 AM

You get that error message during compiling or when it reaches that line of code during execution?
Was This Post Helpful? 0
  • +
  • -

#3 AdamSpeight2008  Icon User is offline

  • MrCupOfT
  • member icon


Reputation: 2268
  • View blog
  • Posts: 9,482
  • Joined: 29-May 08

Re: Parameterised query for sql ce

Posted 11 March 2009 - 01:39 PM

Shouldn't the SQL be?
Dim strSQL As String = "SELECT * FROM tblHoles WHERE (CourseID = '"&TextBox1.Text&"')"

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1