dynamically access table name in select query

Question

hello sir, I am Developing desktop application in which i want to select table name dynamically in select query as per combobox selection in C# desktop Application please give me a proper suggestion

Anil Jha · Answer

You are not setting the value of @TableName variable. In your case it should be parameter and then pass in dynamic sql.

Anil Jha · Answer

Rinku, you can get table name from combo box in variable and then use below sql to fetch the data. declare @TableName varchar (100) declare @SQLQuery nvarchar(2000) set @TableName = 'YOUR TABLE NAME' set @SQLQuery = 'SELECT * FROM ' + @TableName EXECUTE sp_executesql @SQLQuery

Anil Jha · Answer

Create stored procedure like this CREATE PROCEDURE Proc1 @TableName varchar (100) AS declare @SQLQuery nvarchar(2000) BEGIN SET @SQLQuery = 'SELECT * FROM ' + @TableName EXECUTE sp_executesql @SQLQuery END Test stored procedure EXEC Proc1 'Table Name' And then pass tablename variable in c# code.

Rinku Dhadse · Answer

hello sir i have tried above but it gives error as "The request for procedure 'CRIIICCARD' failed because 'CRIIICCARD' is a table object." i have done so many change to solve this error but it never get solved by me please solve my problem why this get happened.. My Storeprocedure: USE[oldoffice2]; SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE sp_executesql AS BEGIN declare @TableName varchar(100) declare @SQLQuery nvarchar(2000) set @SQLQuery = 'SELECT * FROM' + @TableName exec sp_executesql @SQLQuery RETURN END GO My cs code: con.Open(); SqlCommand command = new SqlCommand(); SqlParameter param; command.Connection = con; command.CommandType = CommandType.StoredProcedure; command.CommandText = "sp_executesql"; param = new SqlParameter("@TableName", comboBox1.SelectedItem.ToString()); param.Direction = ParameterDirection.Input; param.DbType = DbType.String; command.Parameters.Add(param);

dynamically access table name in select query

Answers (4)