1. Fill data into data table with stored procedure
_param = new SqlParameter[]
{  new SqlParameter("@SearchTerm",search),
    new SqlParameter("@search",""),
    new SqlParameter("@mobile",""),
   new SqlParameter("@topup",objmodel.user_type),
   new SqlParameter("@fromdate",objmodel.date),
   new SqlParameter("@todate",objmodel.todate),
   new SqlParameter("@PageIndex",1),
   //new SqlParameter("@PageSize",objmodel.pageSize), 
   new SqlParameter("@RecordCount", SqlDbType.Int, 4) { Direction=ParameterDirection.Output}
};
_dt = _sf.returnDtBy_proc("GetCustomers_Pager", _param);
m1.totalCount = _param[7].Value.ToString();
if (_dt.Rows.Count > 0){
}
No comments:
Post a Comment