How can I Add dynamic stored procedure in c#

Question

Hi How can I Add dynamic stored procedure in c#

Manas Mohapatra · Answer

Try like below: string sql = @CREATE PROCEDURE [usp_insertUser]( @AD_Account varchar(255) @AD_SID varchar(255)@AD_EmailAddress varchar(255)) AS BEGIN SET NOCOUNT ON; INSERT INTO AD_Authorization (AD_Account AD_SID AD_EmailAddress) VALUES (@AD_Account@AD_SID@AD_EmailAddress) END); using (SqlConnection connection = new SqlConnection(ConnectionString)) { using (SqlCommand cmd = new SqlCommand(sql connection)) { connection.Open(); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); connection.Close(); } }

Vishal Jadav · Answer

Hi Why do you need such functionality ? If you dont mind please explain. Thanks...

Midhun T P · Answer

Hi Please check below link - http://timtrott.co.uk/creating-stored-procedures/

Vinay Singh · Answer

Hi check the two options Set the SelectCommand of your SqlDataSource to the value in the Session bag every time the page is loaded. Page_Load is a good choice for this. Do away with the SqlDataSource and do it all in code-behind. To do this you could handle the GridViews DataBinding event. In the handler use SqlConnection and SqlCommand (with the command from the Session bag) to get a DataReader (use ExecuteReader on SqlCommand) to set as DataSource on the GridView. See the msdn pages for SqlConnection and SqlCommand on how to use these. For more detail check the link http://p2p.wrox.com/book-asp-net-2-0-website-programming-problem-design-solution-isbn-978-0-7645-8464-0/49429-sql-c-class-vs-dynamic-stored-procedure.html