winform textbox自动检索;textbox智能选择;textbox自动模糊查询; textbox AutoCompleteMode

    #region 
            AutoCompleteStringCollection cs = new AutoCompleteStringCollection();
            this.textBox1.AutoCompleteMode = AutoCompleteMode.Suggest;
            this.textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
            this.textBox1.AutoCompleteCustomSource = cs;
            cs.Clear();
            string sql = "select colum1 from tablename where colum1 is not null";
            DataTable dt = objFrmMain.ObjCDataOperation.MyDB.OpenSQL(sql);
            if (dt != null && dt.Rows.Count > 0)
            {

                foreach (DataRow dr in dt.Rows)
                {
                    cs.Add(dr["colum1"].ToString());
                }

            }

            #endregion

把以上内容放到load里面,适用于数据量小的查询

posted @ 2014-01-07 14:22  潇湘秋月夜  阅读(759)  评论(0编辑  收藏  举报