如何在Window窗体C＃中从数据库自动完成文本框 [英] How to Auto-complete a textbox from database in Window form C#

问题描述

你好，



我想根据数据库中的值创建一个自动完成文本框。如果用户输入任何字母，则该字母与数据库中的值匹配，然后显示。我可以在Web应用程序中执行此操作，但我在Windows窗体应用程序中遇到困难









谢谢!!

Hello,

I want to create an auto complete textbox based on values from a database. If the user enters any letter, then that letter is matched to a value in the database and then is displayed. I can do this in a web application but I am having difficulty with it in a Windows form application




Thank You!!

推荐答案

试试这个链接



http： //webcache.googleusercontent.com/search?q=cache:http://www.csharpaspnetarticles.com/2009/01/winforms-autocomplete-textbox-using-c.html [ ^ ]

在窗体上加载调用文本框自动完成方法autocompleteData。



public void autocompleteData（）

{

// SuggestStrings将具有返回数组的逻辑来自cache / db的字符串

var CurrentuserId = CloudKaseWSClient.GetUserDetail（tokenUsr，tokenPasswd，Username）;

List< string> l =新列表< string>（）;

var SearchResults =（选择数据库查询）。ToList（）;

foreach（搜索结果中的var i）

{

l.Add（i.name）;

}

string [] arr = l.ToArray（ ）;

AutoCompleteStringCollection collection = new AutoCompleteStringCollection（）;

collection.AddRange（arr）;



txtSearchUser .AutoCompleteMode = AutoCompleteMode.SuggestAppend;

txtSearchUser.AutoCompleteSource = AutoCompleteSource.CustomSource;

txtSearchUser.AutoCompleteCustomSource = collection;

}





或者你想为自动完成文本框设置静态数据，而不是必须在AutocompleteMode的Textbox属性的设计视图中设置SuggestAppend，AutocompleteSource来设置海关源和自动完成自定义源中添加静态值。



我希望这个解决方案对你有帮助..

Happy Coding。：）

On Form Load call the Textbox autocomplete method "autocompleteData".

public void autocompleteData()
{
//SuggestStrings will have the logic to return array of strings either from cache/db
var CurrentuserId = CloudKaseWSClient.GetUserDetail(tokenUsr, tokenPasswd, Username);
List<string> l = new List<string>();
var SearchResults = ("Select Database Query").ToList();
foreach (var i in SearchResults)
{
l.Add(i.name);
}
string[] arr = l.ToArray();
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
collection.AddRange(arr);

txtSearchUser.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtSearchUser.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtSearchUser.AutoCompleteCustomSource = collection;
}


OR You want to set static data for AutoComplete Textbox than you have to set In Design view for Textbox property of AutocompleteMode to set SuggestAppend,AutocompleteSource to set CustomSource and add static value inAutocompleteCustomSource.

I hope this solution helps to you..
Happy Coding.:)

这篇关于如何在Window窗体C＃中从数据库自动完成文本框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！