private void FillGrid() { DataTable dtBrand = objDesg.GetStateMaster(Session["CompId"].ToString().ToString()); lblTotalRecords.Text = Resources.Attendance.Total_Records + ": " + dtBrand.Rows.Count + ""; Session["dtState"] = dtBrand; Session["dtFilter"] = dtBrand; if (dtBrand != null && dtBrand.Rows.Count > 0) { GvState.DataSource = dtBrand; GvState.DataBind(); AllPageCode(); } else { GvState.DataSource = null; GvState.DataBind(); } }
public static string[] GetCompletionListState(string prefixText, int count, string contextKey) { StateMaster objState = new StateMaster(); DataTable dt = new DataView(objState.GetStateMaster(HttpContext.Current.Session["CompId"].ToString()), "State like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable(); string[] txt = new string[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { txt[i] = dt.Rows[i]["State"].ToString(); } return(txt); }