How can I Add dynamic stored procedure in c#

Nageshwar Rao

10y852Learn iOS Programming

4 Replies

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

Manas Mohapatra10y ago
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();
    }
}
0
Vinay Singh10y ago
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
-1
Vishal Jadav10y ago
Hi,
Why do you need such functionality ?
If you dont mind please explain.
Thanks...
0
Midhun Tp10y ago
Hi,
Please check below link -
http://timtrott.co.uk/creating-stored-procedures/
0