C# Class AW.DataAccessLayer.DALHelper

Show file Open project: vgopu2/BISummer2015-P1-T2

Public Methods

Method Description
ExecuteNonQuerySP ( string spName, Hashtable spParams ) : int
ExecuteScalarSP ( string spName, Hashtable spParams ) : Object
GetDataReader ( string sqlQuery ) : IDataReader
GetDataset ( string sqlQuery ) : DataSet

Method Details

ExecuteNonQuerySP() public static method

public static ExecuteNonQuerySP ( string spName, Hashtable spParams ) : int
spName string
spParams System.Collections.Hashtable
return int

ExecuteScalarSP() public static method

public static ExecuteScalarSP ( string spName, Hashtable spParams ) : Object
spName string
spParams System.Collections.Hashtable
return Object

GetDataReader() public static method

public static GetDataReader ( string sqlQuery ) : IDataReader
sqlQuery string
return IDataReader

GetDataset() public static method

public static GetDataset ( string sqlQuery ) : DataSet
sqlQuery string
return System.Data.DataSet