private void load_data_2_grid()
 {
     m_ds = new DS_V_GD_HOP_DONG_LAO_DONG();
     m_us.FillDataset(m_ds);
     m_fg.Redraw = false;
     CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans);
     m_fg.Redraw = true;
 }
        private void auto_suggest_text()
        {
            US_V_GD_HOP_DONG_LAO_DONG v_us_v_gd_hop_dong = new US_V_GD_HOP_DONG_LAO_DONG();
            DS_V_GD_HOP_DONG_LAO_DONG v_ds_v_gd_hop_dong = new DS_V_GD_HOP_DONG_LAO_DONG();

            v_us_v_gd_hop_dong.FillDataset(v_ds_v_gd_hop_dong, "WHERE ID_PHAP_NHAN = " + CAppContext_201.getCurrentIDPhapnhan().ToString());

            var v_acsc_search = new AutoCompleteStringCollection();

            foreach (DataRow dr in v_ds_v_gd_hop_dong.V_GD_HOP_DONG_LAO_DONG)
            {
                v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.HO_DEM].ToString() + " " + dr[V_GD_HOP_DONG_LAO_DONG.TEN].ToString());
                v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.MA_NV].ToString());
                v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.MA_HOP_DONG].ToString());
                v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.TEN].ToString());
                v_acsc_search.Add(dr[V_GD_HOP_DONG_LAO_DONG.HO_DEM].ToString());
            }
            m_txt_tim_kiem.AutoCompleteCustomSource = v_acsc_search;
        }