MS SQL

MS SQL RSS

Problems with parameters and selectcommand

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Oct 2008

Posts: 56

Reputation: konczuras is an unknown quantity at this point

Solved Threads: 1

konczuras

Offline

Junior Poster in Training

Problems with parameters and selectcommand

Nov 18th, 2008

Hello Everybody!

I have the following problem: I want to make an application, which need tables to show, edit, etc. You would be able to select the table, which you want to work on, by a dropdownlist (the whole project is in ASP.NET). I want to load the selected table's data to a gridview, and I desperately need a selectcommand for it.
I have succesfully retreived the name of the table, which is selected in the dropdownlist, with a sqlparameter, but can't use it in my selectcommand. The code is the following:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT * FROM (SELECT table_name 
FROM information_schema.TABLES 
WHERE table_name= @table_name)
select * from (Select table_name 
from information_schema.tables 
where table_name= @table_name)

I know it probably looks lame, but the simple

Help with Code Tags

MS SQL Syntax (Toggle Plain Text)

SELECT * FROM @table_name

refused to work too.

To the first one, I get the error message "incorrect syntax near ')'
For the second, it tells me that I must declare the table variable, but I have no idea, how to link it with the dropdownlist.

I thank you forwardly to your help!

•

Join Date: Aug 2008

Posts: 1,160

Reputation: dickersonka will become famous soon enough

Solved Threads: 137

dickersonka dickersonka is offline

Offline

Veteran Poster

Re: Problems with parameters and selectcommand

Nov 18th, 2008

is the first one in a stored procedure? where you pass @table_name in?

Custom Application & Software Development
www.houseshark.net

•

Join Date: Feb 2008

Posts: 42

Reputation: huangzhi is an unknown quantity at this point

Solved Threads: 13

huangzhi

Offline

Light Poster

Re: Problems with parameters and selectcommand

Nov 19th, 2008

change your command into:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT * 
  FROM (SELECT table_name 
             FROM information_schema.TABLES 
             WHERE table_name= @table_name
          ) AliasName
select * 
  from (Select table_name 
             from information_schema.tables 
             where table_name= @table_name
          ) AliasName

change your second command into:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
declare @table_name varchar(255)
SELECT @table_name = 'sysdatabases'
exec ('select * from ' + @table_name)
declare @table_name varchar(255)
select @table_name = 'sysdatabases'
exec ('select * from ' + @table_name)

Hence Wijaya
www.ex-Soft.tk

•

Join Date: Oct 2008

Posts: 56

Reputation: konczuras is an unknown quantity at this point

Solved Threads: 1

konczuras

Offline

Junior Poster in Training

Re: Problems with parameters and selectcommand

Nov 19th, 2008

Thank you for your help, but it still don't works. The first code ignores the 'select * from' from the beginning, and just displays the table name.
The second tells me that the table_name variable is duplicate, so it can't perform it's task.

Any idea, how could I solve this?

Thanks!