How to pass stored procedure in asp.net using C#

Question

Hi I have a report page . using the input parameter get data from DB. How to get through stored procedure in C #

Vinitha T · Answer

Stored Procedure CREATE procedure sp_insert @Name varchar(50), @Department varchar(50) as begin insert into Table(Name,Department) values (@Name,@Department) end Code public bool InsertData(Record record) { int value; using (SqlConnection con = new SqlConnection(ConnectionString)) { con.Open(); SqlCommand cmd = new SqlCommand("sp_insert", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", record.Name); cmd.Parameters.AddWithValue("@Department", record.Department); value=cmd.ExecuteNonQuery(); } return value >= 1 ? true : false; }

sundar lakhman · Answer

hai jignesh, why use sqldata adapter? , here my code, error in sqldataadapter

Satyapriya Nayak · Answer

Hi Arul, Here is an example to insert records into database using stored procedure Stored procedure ALTER PROCEDURE insert1 (@sid varchar(50),@sname varchar(50),@smarks int,@saddress varchar (50),@year varchar(50)) AS insert student(sid,sname,smarks,saddress,year) values (@sid,@sname,@smarks,@saddress,@year) Code part 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_insert { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; DataSet ds; protected void btn_insert_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); com = new SqlCommand("insert1", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@sid", txtid.Text); com.Parameters.AddWithValue("@sname", txtname.Text); com.Parameters.AddWithValue("@smarks", int.Parse(txtmarks.Text)); com.Parameters.AddWithValue("@saddress", txtaddress.Text); com.Parameters.AddWithValue("@year", txtyear.Text); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = "Data entered successfully!!!"; } } } Thanks

Jignesh Trivedi · Answer

Hi Arul, try... DataSet dataset = new DataSet(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = getconnection(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP Name"; // Add Parameter if any... cmd.Parameters.AddWithValue("@parameterName", txetbox.Text); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { // Fill the DataSet using default values for DataTable names, etc da.Fill(dataset); } } hope this will help you.

How to pass stored procedure in asp.net using C#

Answers (4)