public void BindHandOver() { int PAGE_SIZE = ucCustomPager.PageSize; int PAGE_INDEX = ucCustomPager.CurrentPageIndex; int SelectRecordCount = ucCustomPager.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataSet ds = BLL_Crew_CrewList.Get_HandOverDetail_Search(int.Parse(Request.QueryString["ID"].ToString()), int.Parse(Request.QueryString["VESSELID"].ToString()), txtSearchText.Text, sortbycoloumn, sortdirection, PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; txtVesselName.Text = dr["Vessel_Name"].ToString(); txtStaffCode.Text = dr["STAFF_CODE"].ToString(); txtStaffName.Text = dr["FULL_NAME"].ToString(); txtStaffRank.Text = dr["Rank_Name"].ToString(); txtRelievingMasterRemark.Text = dr["Sing_off_Remarks"].ToString(); txtRelievedMasterRemark.Text = dr["Relieved_Master_Remark"].ToString(); if (dr["Joining_Rank"].ToString() != "1") { CheckList.Visible = false; } if (dr["HANDOVER_DATE"] != null) { txtHandOverDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(dr["HANDOVER_DATE"])); } lbltxtRelievingMasterRemark.Text = "Relieving " + txtStaffRank.Text + "'s Remarks :"; lbltxtRelievedMasterRemark.Text = "Relieved " + txtStaffRank.Text + "'s Remarks :"; } gvHandOver.DataSource = ds.Tables[1]; gvHandOver.DataBind(); if (ucCustomPager.isCountRecord == 1) { ucCustomPager.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager.BuildPager(); } }