private void Service_SpareUsage(int pageIndex, int pageSize) { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook() { CustomerName = txtCustomerName.Text.Trim(), RequestNo = txtCallNo.Text.Trim(), ItemId = int.Parse(ddlItem.SelectedValue), EmployeeId_FK = int.Parse(ddlEmployee.SelectedValue), FromDate = (string.IsNullOrEmpty(txtFromLogRequestDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtFromLogRequestDate.Text.Trim()), ToDate = (string.IsNullOrEmpty(txtToLogRequestDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtToLogRequestDate.Text.Trim()), PageIndex = pageIndex, PageSize = pageSize }; DataSet ds = objServiceBook.Service_SpareUsage(serviceBook); gvSpareUsage.DataSource = ds.Tables[0]; gvSpareUsage.VirtualItemCount = (ds.Tables[1].Rows.Count > 0) ? Convert.ToInt32(ds.Tables[1].Rows[0]["TotalCount"].ToString()) : 10; gvSpareUsage.DataBind(); }