protected void Load_CrewList() { //DataTable dtFilters = new DataTable(); //dtFilters.Columns.Add("VesselManager", typeof(int)); //dtFilters.Columns.Add("Fleet", typeof(int)); //dtFilters.Columns.Add("Vessel", typeof(int)); //dtFilters.Columns.Add("RankID", typeof(int)); //dtFilters.Columns.Add("Nationality", typeof(int)); //dtFilters.Columns.Add("Status", typeof(String)); //dtFilters.Columns.Add("ManningOfficeID", typeof(int)); //dtFilters.Columns.Add("EOCDueIn", typeof(int)); //dtFilters.Columns.Add("JoiningDateFrom", typeof(String)); //dtFilters.Columns.Add("JoiningDateTo", typeof(String)); //dtFilters.Columns.Add("SearchText", typeof(String)); //DateTime dtFrom = DateTime.Parse("1900/01/01"); //DateTime dtTo = DateTime.Parse("2900/01/01"); //dtFilters.Rows.Add( // 1, // 0, // 0, // 0, // 0, // "", // 0, // 0, // dtFrom.ToString("yyyy/MM/dd"), // dtTo.ToString("yyyy/MM/dd"), // txtSearchText.Text); //int PAGE_SIZE = 100; //int PAGE_INDEX = 1; int SelectRecordCount = 1; //DataTable dt = BLL_Crew_CrewList.Get_Crewlist_Index(dtFilters, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount); string PBillDate = "01/" + ddlMonth.SelectedValue + "/" + ddlYear.SelectedValue; DataTable dt = BLL_Crew_CrewList.Get_CrewList_Allotment(0, txtSearchText.Text, PBillDate, GetSessionUserID(), 100, 1, ref SelectRecordCount); gvSelectedCrew.DataSource = dt; gvSelectedCrew.DataBind(); }