Products表中有[ProductID],[ProductName],[ProductNameSpell],[MValue]四列
想在文本框中输入的时候自动显示对应的ProductName
private void tb_productName_TextChanged(object sender, EventArgs e)
{
AutoCompleteStringCollection cs = new AutoCompleteStringCollection();
DataTable dt = pm.GetProductByName(tb_productName.Text.Trim());
foreach(DataRow dr in dt.Rows)
{
cs.Add(dr["ProductName"].ToString());
}
tb_productName.AutoCompleteCustomSource = cs;
tb_productName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
tb_productName.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
比如Products中有豆油、豆粕,我在文本框中输入d的时候显示不出来,只有输入汉字的时候才可以显示出来提示。
但是调试的时候输入d时,cs的确包含豆油和豆粕,求教啊~
想在文本框中输入的时候自动显示对应的ProductName
private void tb_productName_TextChanged(object sender, EventArgs e)
{
AutoCompleteStringCollection cs = new AutoCompleteStringCollection();
DataTable dt = pm.GetProductByName(tb_productName.Text.Trim());
foreach(DataRow dr in dt.Rows)
{
cs.Add(dr["ProductName"].ToString());
}
tb_productName.AutoCompleteCustomSource = cs;
tb_productName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
tb_productName.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
比如Products中有豆油、豆粕,我在文本框中输入d的时候显示不出来,只有输入汉字的时候才可以显示出来提示。
但是调试的时候输入d时,cs的确包含豆油和豆粕,求教啊~
0x0080. Windows Vista and later. If set, the autocompleted suggestion is treated as a phrase for search purposes. The suggestion, Microsoft Office, would be treated as "Microsoft Office" (where both Microsoft AND Office must appear in the search results).
ACO_NOPREFIXFILTERING
0x0100. Windows Vista and later. Disable prefix filtering when displaying the autosuggest dropdown. Always display all suggestions.你注意,这两个特性是Vista才有的。如果你能保证你的系统是运行在这样的版本上,你可以用API SHAutoComplete IAutoComplete2::SetOptions等等。
http://jiangsheng.net/2007/08/06/autocomplete-with-datasource/?like=1
3层架构里面的实体层的类中如何体现外键,一直没有找到个demo,可耻了