how to get all code of stored procedure in c#.net window and create textFile of storedprocedure in C#.net window Application

Question

I Want get All Code of stored procedure from database and convert that procedure in textfile and save that textfile in particular path in c#.net window application.

Answer 1

In order to get the code for a stored procedure, you're probably going to have to query the system tables in the database. Look at the documentation for whatever RDBMS you're using.

As far as saving a text file goes, take a look at this howto.

Answer 2

With thanks to David Cumps (Assuming SQL Server):

SELECT text 
FROM syscomments 
WHERE id = (SELECT id FROM sysobjects WHERE name = '{0}') 
ORDER BY colid

Execute this query from your app then concatenate the results.