通过winfrom内置的AutoCompleteStringCollection类的字符串集合功能,通过AutoCompleteSource.CustomSource绑定字符串的数据。
AutoCompleteStringCollection strings = new AutoCompleteStringCollection();
SqlContent UserLogin = new SqlContent();
DataSet ds1 = UserLogin.SelectMand("select [BarCode] from [Commodity]");
//这里你需要修改,遍历数据库里的数据
foreach (DataRow row in ds1.Tables[0].Rows)
{
strings.Add(row[0].ToString());
}
textBallCade.AutoCompleteCustomSource = strings;
textBallCade.AutoCompleteMode = AutoCompleteMode.SuggestAppend;//设置自动完成的的形式
textBallCade.AutoCompleteSource = AutoCompleteSource.CustomSource;//设置自动完成的源