public static SqlDataReader GetDataReader(string strConnect, string procName)
{
//**************************************
//* Purpose: Getting DataReader for the given Procedure
//* Input parameters:
//*procName ---StoredProcedures name
//* Returns :
//*DataReader contains data
//* ************************************
string strCommandText = procName;
SqlDataReader objDataReader;
//create a new Connection object using the connection string
var objConnect = new SqlConnection(strConnect);
//create a new Command using the CommandText and Connection object
var objCommand = new SqlCommand(strCommandText, objConnect) {CommandTimeout = 3600};
//set the timeout in seconds
try
{
//open the connection and execute the command
objConnect.Open();
//objDataAdapter.SelectCommand = objCommand
objDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception objError)
{
objConnect.Close();
objConnect.Dispose();
//write error to the log
Errhandle.StopProcessing(objError, strCommandText);
//Console.WriteLine(objError.Message.ToString());
//Console.WriteLine("Query -----------\r\n" + strCommandText);
throw;
}
return objDataReader;
}