public DataSet Execute_StoreProc_DataSet(string psStoreProcName) { DataSet dsResult= new DataSet(); UtilParams objParams; SqlConnection objConnection=null; SqlParameter objSqlParams=null; SqlCommand objCommand=null; SqlDataAdapter objSqlDataAdapter=null; try { objConnection=getConnection(); objCommand= new SqlCommand(psStoreProcName,objConnection); objCommand.CommandType=CommandType.StoredProcedure; objCommand.CommandTimeout = 0; IDictionaryEnumerator en = mhtParamCollection.GetEnumerator(); while (en.MoveNext()) { objParams=(UtilParams)en.Value; objSqlParams = new SqlParameter(); objSqlParams.ParameterName=objParams.ParamName; objSqlParams.SqlDbType =(SqlDbType)objParams.ParamType; objSqlParams.Direction=objParams.Direction; if (objParams.Direction==ParameterDirection.Output) { objSqlParams.Size=objParams.ParamSize; } objSqlParams.Value= objParams.ParamValue; objCommand.Parameters.Add(objSqlParams); } objSqlDataAdapter= new SqlDataAdapter(objCommand); objSqlDataAdapter.Fill(dsResult); return dsResult; } catch(Exception Ex) { //ErrorHandler objERR = new ErrorHandler(); //objERR.WriteError(DateTime.UtcNow + ", DAL.DBUtility-Execute_StoreProc_DataSet(): " + Ex.Message.ToString() + " " + Environment.UserName, Environment.UserName); throw; } finally { objCommand.Dispose(); objSqlDataAdapter.Dispose(); if (objConnection.State ==ConnectionState.Open) objConnection.Close(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)