ASP.NET学习网|ASP.NET教程|ASP.NET MVC|ASP.NET 源码|VS2010教程|ASP.NET视频教程

private void dgv_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            if (e.Control is DataGridViewTextBoxEditingControl)
            {
                DataGridView dgv = (DataGridView)sender;
                DataGridViewTextBoxEditingControl tb = (DataGridViewTextBoxEditingControl)e.Control;
                if (dgv.CurrentCell.OwningColumn.HeaderText=="产品代码")
                {
                    DataSet ds=base.GetDataSetFromSql("SELECT Fnumber AS 代码 FROM B_Material");
                    BuildAutoCompleteList(tb,ds);
                }
                else if (dgv.CurrentCell.OwningColumn.HeaderText=="仓库")
                {
                    DataSet ds = base.GetDataSetFromSql("SELECT Fnumber AS 代码 FROM B_Stock");
                    BuildAutoCompleteList(tb,ds);
                }
            }
        }

        private void BuildAutoCompleteList(DataGridViewTextBoxEditingControl tb, DataSet dsPopInforma)
        {
            tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
            tb.AutoCompleteSource = AutoCompleteSource.CustomSource;
            tb.Margin = new Padding(0);
            AutoCompleteStringCollection filterVals = new AutoCompleteStringCollection();
            for (int i = 0; i < dsPopInforma.Tables[0].Rows.Count; i++)
            {
                filterVals.Add(dsPopInforma.Tables[0].Rows[i]["代码"].ToString());
            }
            tb.AutoCompleteCustomSource = filterVals;
        }

效果图