public void FormProductSearch_Load(object sender, EventArgs e)
{
DataBaseOperationDLL db = new DataBaseOperationDLL();
DataTable dt = db.AllProductInformation();
dataGridView1.DataSource = dt;
List <string> list = new List <string>();
foreach (DataRow dr in dt.Rows)
{
if (dr["product_number"].ToString().Length != 0)
{
list.Add(dr["product_number"].ToString());
}
if (dr["product_name"].ToString().Length != 0)
{
list.Add(dr["product_name"].ToString());
}
}
AutoCompleteStringCollection source = new AutoCompleteStringCollection();
source.AddRange(list.ToArray());
tbNameOrNumber.AutoCompleteCustomSource = source;
tbNameOrNumber.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
tbNameOrNumber.AutoCompleteSource = AutoCompleteSource.CustomSource;
dataGridView1.ClearSelection();//清除选中状态
}
