Passing Table Name as parameter in stored procedure in c#

Question

0.00/5 (No votes)

See more:

I am working on a project and that project need to make table name dynamic, means i want to pass table name as a parameter in my stored procedure from front end. So that i can communicate any table with same table structure....

Thanks in advance..........

pls help....

Posted 2-May-13 10:32am

Anjanee Kumar Singh

Add a Solution

Comments

Christian Graus 26-Dec-13 5:23am

As the first answerer told you, this is a stupid thing to do. Your schema should NOT be so fluid that you need dynamic table names. You should rethink your schema to lose this requirement

3 solutions

Solution 2

http://www.daniweb.com/software-development/csharp/threads/370541/pass-table-name-as-a-parameter-in-stored-procedure-using-c[^]

Posted 25-Dec-13 23:05pm

Member 10248737

Solution 3

pass table name as a string and in store procedure write a query statement in varchar and finally execute using exec method to that statement.

Posted 25-Dec-13 23:14pm

sufiyakhan

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Accepted Answer · 2013-05-02T10:46:00

You can use dynamic query approach. You practically build your query as string and execute it inside the procedure, so you can use your table name as parameter. Look here: Building Dynamic SQL In a Stored Procedure[^]. But it rarely wise to do so. You will end up with an unsustainable application. You better put your DAL and BL "near" the DBMS, and solve this need on a higher level.

Passing Table Name as parameter in stored procedure in c#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Passing Table Name as parameter in stored procedure in c#

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us