搜索组合框(如Google搜索) [英] Search Combo Box like Google Search

问题描述

我正在制作Windows窗体，其中有一个组合框，已从SQL Server 2010中装入一些发票编号". 我想在用户在组合"框中键入时显示发票编号. 例如，如果用户键入"100"，则下拉列表中应显示以"100"开头的发票编号.

I am making a Windows Form in that I have A combo box, Into which i have loaded some 'Invoice Numbers', from SQL server 2010. I want to Display Invoice Numbers as the User types into the Combo box. For eg if User types '100' then the Invoice Numbers Starting with '100' should be displayed in the dropdown.

请帮助， 在此先感谢...

Please Help, Thanks in Advance...

推荐答案

    DataTable temp;
    DataTable bank;
    private void Form1_Load(object sender, EventArgs e)
    {
        comboBox1.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
        comboBox1.AutoCompleteSource = AutoCompleteSource.ListItems;

        temp = DbRdRw.SqlDbRead("Select * from BankMaster", "BankMaster");

        DataView dtview = new DataView(temp);
        dtview.Sort = "BankName DESC";
        bank = dtview.ToTable();

        comboBox1.DataSource = bank;
        comboBox1.ValueMember = "BankName";
        comboBox1.DisplayMember = "BankName";
    }

这篇关于搜索组合框(如Google搜索)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！