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);
    }