public static Resultset <DataSet> GetDataSetWithStoreprocedure(String strStoreProceureName, DBParams dbpParameterName)
{
MasterDal oDal = new MasterDal();
Resultset <DataSet> oDStore = oDal.ExecuteDataSet(strStoreProceureName, dbpParameterName);
oDal.Dispose();
oDal = null;
return(oDStore);
}
//public static DataSet GetDatasetUsingProcedure(string OstoredProcName, DBParams OparameterValues)
//{
// MasterDal oDal = new MasterDal();
// DataSet oDS = oDal.ExecuteDataSet(OstoredProcName,OparameterValues);
// oDal.Dispose();
// oDal = null;
// return oDS;
//}
public static DataSet GetDataset(String SQL)
{
MasterDal oDal = new MasterDal();
DataSet oDS = oDal.ExecuteDataSet(SQL);
oDal.Dispose();
oDal = null;
return(oDS);
}
