How to use Stored Procedure In ASP .Net

Question

How to use Stored Procedure In ASP .Net. please send samples with Examples. Thanks&Regs Manavalan

magesh manavalan · Answer

Thank you my dear Priya

Senthilkumar · Answer

Hi, SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.StoredProcedure; //Three Types: Text, StoredProcedure, TableDirect sqlCommand.Text = "proc_AddTwoNumbers"; if you have parameter to the stored procedure then sqlCommand.Parameters.Add("@ProcedureArqument1",ParamValue1); sqlCommand.Parameters.Add("@ProcedureArqument2",ParamValue2); The first arqument is the sql stored procedure paramter name, passing value and the third parameter is data type.

Satyapriya Nayak · Answer

If this post helps you mark it as answer Thanks

Satyapriya Nayak · Answer

Hi Magesh, Here is an example how to display records using stored procedure. Untitled Page using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Stored_procedure_to_display { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); com = new SqlCommand("display", con); com.CommandType = CommandType.StoredProcedure; sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds, "student"); GridView1.DataSource = ds; GridView1.DataMember = "student"; GridView1.DataBind(); con.Close(); } } } Stored procedure ALTER PROCEDURE display AS select * from student Thanks If this post helps you mark it as answer

How to use Stored Procedure In ASP .Net

Answers (4)