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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)