How to execute sql insertion stored procedure in c# code

Question

How to execute sql insertion stored procedure in c# code ? acutally i mean that i have create a public connection class in c# and i want to execute insertion sp to insert value for this i desired to create a function thorugh which i do such kindly help

Bhuvan Pandey · Answer

Hi Muqdas, This is complete code to executestored procedure in C#. SqlConnectioncon= new SqlConnection( " " ); con.Open(); SqlCommandcom= new SqlCommand( " " ,con); com.CommandType=CommandType.StoredProcedure; com.Parameters.AddWithValue( " " , " " ); int flag=com.ExecuteNonQuery(); con.Close();

Ravi Patel · Answer

Hi , check this http://www.codeproject.com/Articles/748619/ADO-NET-How-to-call-a-stored-procedure-with-output http://www.aspsnippets.com/Articles/Getting-ID-of-the-newly-inserted-record-in-SQL-Server-Database-using-ADO.Net.aspx

Gowtham K · Answer

Hi Muqdas, Using the Sql Command function called ExecuteNonQuery we can execute the insertion SP Pls refer below links: http://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx http://www.aspdotnet-suresh.com/2015/07/aspnet-gridview-crud-operations-insert-select-edit-update-delete-using-single-stored-procedure-example.html

How to execute sql insertion stored procedure in c# code

Answers (3)