Hi, I have datareader useing this objectcommand and sqlstring. When I hard code the name of the table it works with the param "@puser" but when I use as below I get an error that says I must declare the variable @ptable.
Can you not use a parameter for the table name?

 Dim strSQL As String = "SELECT email From @ptable Where fullname = @pUser "
        Dim objCMD As New SqlCommand(strSQL, objConn)
        With objCMD.Parameters
            .Add(New SqlParameter("@ptable", strTable))
            .Add(New SqlParameter("@puser", strUser))
        End With

Thanks for the help
Raif

It may depend on which database you are using in the back end, but as a general rule, no, you cannot pass table names as variables.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

Raif,

When is that you decide the table name? If you have the table name decided before you construct this select statement, you can probably use this way, which is done in the frontend, well before it hits the DB for executing the query.

suppose strTblName contains the table name that you wanted to query.

Dim strSQL As String = "SELECT email From " & strTblName & " Where fullname = @pUser"

You cannot pass table name as parameter with the kind of approach you have here. Not sure if you are using SQL server/any other DB. If SQL server, then you can create stored proc that constructs the sql string and use exec() function to run that.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection