Thursday, December 23, 2021

Fill data with stored procedure in data table

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

Linq Expression syntax for where condtion in linq

(Expression<Func<T, bool>> filter)