In Code Behind, What is proper select statement syntax to retrieve the @BName field from a table?
Using Visual Studio 2003
SQL Server DB

I created the following parameter:
Dim strName As String
        Dim parameterBName As SqlParameter = New SqlParameter("@BName", SqlDbType.VarChar, 50)
        parameterBName.Value = strName
        myCommand.Parameters.Add(parameterBName)

I tried the following but get error:
Dim strSql As String = "select @BName from Borrower where BName= DOROTHY V FOWLER "

error is:
Line 1: Incorrect syntax near 'V'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'V'.

Source Error:


Line 59:
Line 60:
Line 61: myCommand.ExecuteNonQuery() 'Execute the query

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'.

I am not sure I understand what you're trying to do...

You have a variable called strName, but never assign it a value. And where does 333-00-1492 come from? I thought you needed 767?

Anyway, if I were you, I'd try a simple query first. E.g.

"select BName from Borrower where TaxID = 767"

assuming the TaxId is a number or

"select BName from Borrower where TaxID = '767'"

If that works, then you can modify the statement to insert a parameter:

"select BName from Borrower where TaxID = @taxId"

Then you can set up a parameter for the @taxId param.

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004