Click here to Skip to main content
15,892,537 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Wake on lan how to? Pin
DaveAuld10-May-10 5:11
professionalDaveAuld10-May-10 5:11 
GeneralRe: Wake on lan how to? Pin
Cosby10-May-10 5:45
Cosby10-May-10 5:45 
GeneralRe: Wake on lan how to? Pin
DaveAuld10-May-10 6:26
professionalDaveAuld10-May-10 6:26 
QuestionArchitecture Pin
Archimedes249-May-10 21:56
professionalArchimedes249-May-10 21:56 
AnswerRe: Architecture Pin
Johan Hakkesteegt9-May-10 23:02
Johan Hakkesteegt9-May-10 23:02 
AnswerRe: Architecture Pin
Henry Minute10-May-10 1:18
Henry Minute10-May-10 1:18 
QuestionProblem with syntax with Wizard in a Select/Where statement Pin
Peter Leipzig9-May-10 20:20
Peter Leipzig9-May-10 20:20 
AnswerRe: Problem with syntax with Wizard in a Select/Where statement Pin
Johan Hakkesteegt9-May-10 21:17
Johan Hakkesteegt9-May-10 21:17 
The problem is that you are trying to apply Access techniques on vb.net.

The wizard does not, and will not ever understand that WHERE [Boat Name] = '" & xid & "' means that you want to use a variable.

Try writing the sql sentence in the wizard, and apply your variable like so: WHERE [Boat Name] = @xid. Then, in your vb.net code, before you call the DataAdapter.Fill method pass your variable's value to the adapter's parameter collection.

Something like: DataAdapter.SelectCommand.Parameters.Add("@xid", NVarChar).Value = xid (you probably have to check for the correct syntax, but something along these lines anyway)

As an added bonus you will be using the safe way to use parameterized queries (much less risk of an sql injection attack).
My advice is free, and you may get what you paid for.

GeneralRe: Problem with syntax with Wizard in a Select/Where statement Pin
Peter Leipzig10-May-10 9:01
Peter Leipzig10-May-10 9:01 
GeneralRe: Problem with syntax with Wizard in a Select/Where statement Pin
Johan Hakkesteegt10-May-10 20:58
Johan Hakkesteegt10-May-10 20:58 
QuestionHelp Me Pin
MdUmair9-May-10 11:46
MdUmair9-May-10 11:46 
AnswerRe: Help Me Pin
Henry Minute10-May-10 1:21
Henry Minute10-May-10 1:21 
QuestionMulty threading question Pin
Pasan1488-May-10 23:08
Pasan1488-May-10 23:08 
AnswerRe: Multy threading question Pin
Dimitri Witkowski9-May-10 0:01
Dimitri Witkowski9-May-10 0:01 
GeneralRe: Multy threading question Pin
Pasan1489-May-10 0:51
Pasan1489-May-10 0:51 
GeneralRe: Multy threading question Pin
Dimitri Witkowski9-May-10 1:29
Dimitri Witkowski9-May-10 1:29 
AnswerRe: Multy threading question Pin
Luc Pattyn9-May-10 1:59
sitebuilderLuc Pattyn9-May-10 1:59 
AnswerRe: Multy threading question Pin
Yosh_10-May-10 2:12
professionalYosh_10-May-10 2:12 
QuestionAdapting a DLL to VB.NET, using PINVOKE Pin
Hrizip8-May-10 8:44
Hrizip8-May-10 8:44 
AnswerRe: enum, hex literals Pin
Luc Pattyn8-May-10 9:29
sitebuilderLuc Pattyn8-May-10 9:29 
GeneralRe: enum, hex literals Pin
Hrizip8-May-10 10:38
Hrizip8-May-10 10:38 
GeneralRe: enum, hex literals Pin
Hrizip8-May-10 22:10
Hrizip8-May-10 22:10 
GeneralRe: enum, hex literals Pin
Luc Pattyn9-May-10 2:02
sitebuilderLuc Pattyn9-May-10 2:02 
GeneralRe: enum, hex literals Pin
Hrizip9-May-10 2:36
Hrizip9-May-10 2:36 
AnswerRe: P/Invoke Pin
Luc Pattyn8-May-10 9:38
sitebuilderLuc Pattyn8-May-10 9:38 

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.