stored procedure in asp.net

Question

how to use an inbuild stored procedure in asp.net. I have a stored procedure. i have to use it in my program in asp.net .how to do that?

Ananth G · Answer

ExecuteReader Code: You only modify your parameters , procedure name and connection String . FunForExecuteReader method is a dynamic mehtod so you don't any change in this code part. this below code for oracle data provider. public static DataTable GetDealerDetails() { OracleParameterCollection parameterCollection = new OracleParameterCollection(); parameterCollection.Add(new OracleParameter("OP_List", OracleType.Cursor)); parameterCollection["OP_List"].Direction = ParameterDirection.Output; OracleParameter[] parameter = new OracleParameter[parameterCollection.Count]; parameterCollection.CopyTo(parameter, 0); parameterCollection.Clear(); OracleDataReader dataReader = DataAccessLayer.FunForExecuteReader("YOUR PROCEDURE NAME", parameter, "YOUR CONNECTION STRING"); DataTable objDtData = new DataTable(); if (dataReader != null) { objDtData.Load(dataReader); } return objDtData; } public static OracleDataReader FunForExecuteReader(string commandText, OracleParameter[] commandParameters,string ConnString) { OracleConnection connection = new OracleConnection(ConnString); if (connection.State != ConnectionState.Open) { connection.Open(); } OracleDataReader dataReader = null; using (OracleCommand command = new OracleCommand()) { command.CommandTimeout = 1200; command.Connection = connection; command.CommandText = commandText; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddRange(commandParameters); //if (commandParameters != null) //{ // AttachParameters(command, commandParameters); //} dataReader = command.ExecuteReader(); } return dataReader; }

Delpin Susai Raj · Answer

https://m.youtube.com/watch?v=EXTmMQMEnDs

Delpin Susai Raj · Answer

http://asp.net-informations.com/dbpro/asp-procedures.htm

Pragati Garg · Answer

Thanks

Midhun T P · Answer

Hi, Please check below articles- http://www.c-sharpcorner.com/article/using-stored-procedures-with-Asp-Net/ http://www.aspsnippets.com/Articles/Select-SQL-Server-Stored-Procedures-using-ASPNet-Example.aspx

Bikesh Srivastava · Answer

check it.. SqlConnectionsqlConnection1= new SqlConnection( "YourConnectionString" ); SqlCommandcmd= new SqlCommand(); SqlDataReaderreader; cmd.CommandText= "StoredProcedureName" ; cmd.CommandType=CommandType.StoredProcedure; cmd.Connection=sqlConnection1; sqlConnection1.Open(); reader=cmd.ExecuteReader(); //DataisaccessiblethroughtheDataReaderobjecthere. sqlConnection1.Close();

stored procedure in asp.net

Answers (6)