How to pass tablename as parameter to Stored Procedures

Passing Tablename

create procedure SAll (@tablename varchar(25))
as
EXEC (‘select * from ‘ + @tablename)

udhaya

PiSquare Soft Solns

How to execute Stored Procedure in C#

Executing Stored Procedure in C#

SQLCommand Command = new SqlCommand(“StoredProcedureName”, Connection);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.Add(new SqlParameter(“@Param1”, comboBox1.Text));

//@Param1-Var Name you declare in Stored Procedure;comboBox1.Text-Value to be passed for that Var
Command.Parameters.Add(new SqlParameter(“@Param2”, textBox1.Text));
Command.Parameters.Add(new SqlParameter(“@Param3”, dateTimePicker1.Value));

Command.ExecuteNonQuery();

Udhaya

PiSquare