public static string[] GetCompletionList(string prefixText, int count, string contextKey) { Set_AddressCategory obj = new Set_AddressCategory(); DataTable dt = obj.GetDistinctAddressName(HttpContext.Current.Session["CompId"].ToString(), prefixText); string[] str = new string[dt.Rows.Count]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { str[i] = dt.Rows[i][0].ToString(); } } else { if (prefixText.Length > 2) { str = null; } else { dt = obj.GetAddressCategoryTrueAll("1"); if (dt.Rows.Count > 0) { str = new string[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { str[i] = dt.Rows[i]["Address_Name"].ToString(); } } } } return(str); }
private void FillGrid() { DataTable dtBrand = objAddCat.GetAddressCategoryTrueAll(StrCompId.ToString()); lblTotalRecords.Text = Resources.Attendance.Total_Records + ": " + dtBrand.Rows.Count + ""; Session["dtAddressCategory"] = dtBrand; Session["dtFilter"] = dtBrand; if (dtBrand != null && dtBrand.Rows.Count > 0) { GvAddressCategory.DataSource = dtBrand; GvAddressCategory.DataBind(); } else { GvAddressCategory.DataSource = null; GvAddressCategory.DataBind(); } AllPageCode(); }