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[] commandParametersstring 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();