Data Access Layer-- PART-1

BangaruBabu
Posted by BangaruBabu under ASP.NET category on | Views : 2463
public static void CacheParameterSet(string commandText, params
SqlParameter[] objparams)
{
SqlHelperParameterCache.CacheParameterSet(getConnection(), commandText,
objparams);
}
------------------------


public static SqlDataReader ExecuteDataReader(string strSelect)
{
SqlDataReader reader;
try
{
reader = SqlHelper.ExecuteReader(getConnection(), CommandType.Text,
strSelect);
}
catch (SqlException exception)
{
throw exception;
}
catch (Exception exception2)
{
throw exception2;
}
return reader;
}

--------------

public static DataSet ExecuteDataset(string strSelect)
{
DataSet set;
try
{
set = SqlHelper.ExecuteDataset(getConnection(), CommandType.Text, strSelect);
}
catch(SqlException exception)
{
throw exception;
}
catch (Exception exception2)
{
throw exception2;
}
return set;
}

Comments or Responses

Login to post response