/// <Summary>
/// Obtain the dataset
/// </Summary>
/// <Param name = "tblName"> table name </param>
/// <Param name = "RetColumns"> columns to be returned. The default value is all. </param>
/// <Param name = "orderparts"> name of the sorting field </param>
/// <Param name = "PageSize"> page size </param>
/// <Param name = "PageIndex"> page number </param>
/// <Param name = "IsCount"> total number of returned records. If the value is not 0, return </param>
/// <Param name = "OrderType"> set the sorting type. If the value is not asc, the sorting type is descending. </param>
/// <Param name = "strWhere"> query condition (Note: Do not add where) </param>
/// <Returns> dataset </returns>
Public static SqlDataReader Get_DataReader (string tblName, string RetColumns, string orderader, int PageSize, int PageIndex, int IsCount, string OrderType, string strWhere)
{
IDataParameter [] parameters = new SqlParameter [8];
Parameters [0] = new SqlParameter ("@ tblName", SqlDbType. NVarChar, 255); // table name
Parameters [1] = new SqlParameter ("@ RetColumns", SqlDbType. NVarChar, 1000); // columns to be returned, all by default
Parameters [2] = new SqlParameter ("@ ordereter", SqlDbType. NVarChar, 255); // sort field name
Parameters [3] =