Loading

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

B M Suchitra

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

B M Suchitra15y ago
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?
0
Mamta M15y ago
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.
0