Click here to Skip to main content
15,905,607 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Commport Pin
progload9-Apr-06 6:31
progload9-Apr-06 6:31 
Questionsending serial data using rs232 Pin
hackerz838-Apr-06 21:09
hackerz838-Apr-06 21:09 
AnswerRe: sending serial data using rs232 Pin
Joshua Quick9-Apr-06 11:32
Joshua Quick9-Apr-06 11:32 
GeneralRe: sending serial data using rs232 Pin
hackerz839-Apr-06 20:54
hackerz839-Apr-06 20:54 
AnswerRe: sending serial data using rs232 Pin
Joshua Quick9-Apr-06 23:21
Joshua Quick9-Apr-06 23:21 
QuestionVB.NET: COM Interop. Sink event to COM Client Pin
mdepaepe8-Apr-06 19:03
mdepaepe8-Apr-06 19:03 
QuestionIn Code Behind, What is proper select statement syntax to retrieve the @BName field from a table? Pin
kenn_rosie8-Apr-06 17:04
kenn_rosie8-Apr-06 17:04 
AnswerRe: In Code Behind, What is proper select statement syntax to retrieve the @BName field from a table? Pin
kenn_rosie8-Apr-06 17:49
kenn_rosie8-Apr-06 17:49 
Sorry: To further clarify
My database table name is borrower and two of the fields are BName and TaxID, I am trying to select a particular borrower (BName) with a taxid OF 767, lets say in this case THE BORROWER IS Bill Jones

I declared the following variables:
Dim strName As String
Dim parameterBName As SqlParameter = New SqlParameter("@BName", SqlDbType.VarChar, 50)
parameterBName.Value = strName
myCommand.Parameters.Add(parameterBName)
Dim strTaxID As String
Dim ParameterTaxID As SqlParameter = New SqlParameter("@TaxID", SqlDbType.VarChar, 15)
ParameterTaxID.Value = strTaxID
myCommand.Parameters.Add(ParameterTaxID)

I inserted the folowing command:

Dim strSql As String = "select BName from Borrower where TaxID= @333-00-1492 "

I get error:
Must declare the variable '@333'.




GeneralRe: In Code Behind, What is proper select statement syntax to retrieve the @BName field from a table? Pin
Colin Angus Mackay8-Apr-06 19:09
Colin Angus Mackay8-Apr-06 19:09 
QuestionPanel control movement problem Pin
MWashburn8-Apr-06 14:30
MWashburn8-Apr-06 14:30 
QuestionHow to Capture image from WebCam Or IP Camera Pin
WindDance8-Apr-06 2:12
WindDance8-Apr-06 2:12 
QuestionHow can Remoting From vb.net code Pin
Arag038-Apr-06 1:15
Arag038-Apr-06 1:15 
AnswerRe: How can Remoting From vb.net code Pin
Colin Angus Mackay8-Apr-06 19:11
Colin Angus Mackay8-Apr-06 19:11 
QuestionCrystal Report Problem Pin
microuser_20008-Apr-06 1:09
microuser_20008-Apr-06 1:09 
Questionsmall error Pin
Amit Agarrwal7-Apr-06 23:39
Amit Agarrwal7-Apr-06 23:39 
AnswerRe: small error Pin
Colin Angus Mackay8-Apr-06 0:01
Colin Angus Mackay8-Apr-06 0:01 
Questionplease help how to pass enter Pin
Amarni7-Apr-06 21:08
Amarni7-Apr-06 21:08 
AnswerRe: please help how to pass enter Pin
Chatura Dilan8-Apr-06 1:00
Chatura Dilan8-Apr-06 1:00 
QuestionDatareports in vb6 Pin
rais patel7-Apr-06 20:03
rais patel7-Apr-06 20:03 
AnswerRe: Datareports in vb6 Pin
Vikrant Badhai7-Apr-06 23:17
Vikrant Badhai7-Apr-06 23:17 
QuestionRepeater Control is not working Pin
Amit Agarrwal7-Apr-06 19:09
Amit Agarrwal7-Apr-06 19:09 
GeneralRe: Repeater Control is not working Pin
Guffa7-Apr-06 22:46
Guffa7-Apr-06 22:46 
GeneralRe: Repeater Control is not working Pin
Amit Agarrwal7-Apr-06 23:12
Amit Agarrwal7-Apr-06 23:12 
GeneralRe: Repeater Control is not working Pin
Guffa8-Apr-06 0:23
Guffa8-Apr-06 0:23 
Questionprinting Pin
maytel7-Apr-06 18:06
maytel7-Apr-06 18:06 

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.