Want to write a dynamic Stored Procedure in code behind using c# in aspx page

Question

Hi I want to write a single stored procedure for insert update delete and that too in code behind in aspx page using c#. How do i write it please suggest.. I have read somewhere that for maintaince purpose it is good to write stored procedure in code behind instead of writing in database.

B M Suchitra · Answer

Yes like Nethras thread.. I want to create SP in that way. Everything dynamically. Is it the right way to create SP in code behind instead of writing in database?

Mamta M · Answer

By dynamic do you mean like how Nethra wanted in this question or do you want to hardcode your table names etc? In Nethra's case everything is generic so it can be supplied dynamically. http://www.c-sharpcorner.com/Forums/Thread/149222/dynamically-generate-sql-query-in-code-behid-using-C-Sharp.aspx However if that's not what you want and you want a simple stored procedure in which the names are pre-fixed then that's very easy. But first you need to clarify to us what you want.