private void Form1_Load(object sender, EventArgs e)
{
	sqlconn = new SqlConnection(mainconn); 
	sqlconn.Open();
	string sqlquery = "select Uname from [dbo].[MVCregUser]";
	sqlcomm = new Sq1Command(sqlquery, sqlconn);
	sdr = new SqlDataAdapter(sqlcomm); 
	dt = new DataTable(); 
	sdr.fill(dt);
	comboBox1.DisplayMember = "Uname"; 
	comboBox1.DataSource = dt;
	dataGridView1.DataSource = dt;
	comboBox1.AutoCompleteMode = AutoCompleteMode.Suggest;
	comboBox1.AutoCompleteSource = AutoCompleteSource.ListItems; 
	sqlconn.Close();
}
在datagridview中的datagridviewcomboBoxcolumn象如下设计:
private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
	if (e.Control is DataGridViewComboBoxEditingControl)
	{
		((ComboBox)e.Control).DropDownStyle = ComboBoxStyle.DropDown;
		((ComboBox)e.Control).AutoCompleteSource = AutoCompleteSource.ListItems;
		((ComboBox)e.Control).AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest;
	}
}
TextBox的补齐
private void Form1_Load(object sender, EventArgs e)
{
	string mainconn = ConfigurationManager.ConnectionStrings["Myconn"].ConnectionString SqlConnection sqlconn = new SqlConnection(mainconn); 
	string sqlquery = "select Name From[dbo][Employee]";
	SqlCommand sqlcomm = newSqCommand(sqlquerysqlconn);
	sqlconn.Open(();
	SqlDataReader sdr = sqlcommExecutReader();
	AutoCompleteStringCollection autotext = new AutoCompleteStringCollection():
	while (sdr.Read())
	{
		autotext.Add(sdr.GetString(0));
	}
	textBox1.AutoCompleteMode = AutoCompleteMode.Suggest;
	textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
	textBox1.AutoCompleteCustomSource = autotext; 
	sqlconn.close();
}