How to make my combobox autocomplete with multiple columns

Black Diamond

Hi!

I want to ask some help this problem. I want my combobox autocomplete dropdown in how many columns and merge the rows in one combo box text.

=====================================================================

string conStringBranchFund = txtpath;
SqlConnection connBranchFund = new SqlConnection(conStringBranchFund);
connBranchFund.Open();
string query = "select AccountNumberBranch, AccountBank, AccountNumber from AccountNumBranch order by AccountNumber";
SqlCommand cmd = new SqlCommand(query, connBranchFund);
SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{

CbBranchFunds.Text = reader.GetString(0) + " (" + reader.GetString(1) + ") " + reader.GetString(2);
}

====================================================================

This code display only one row, the last row. I want to be drop completely in how many columns ...thank you in advance.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
You can use Draw method to paint the items as suggested by members or you can use the below one (as you had already done something good)
while (reader.Read())
{
CbBranchFunds.Items.Add(reader.GetString(0) + " (" + reader.GetString(1) + ") " + reader.GetString(2));
}
if(CbBranchFunds.Items.Count>0)
    CbBranchFunds.SelectedIndex=0;
+1
Black Diamond9y ago
Thank you sir Amit Gupta,

You last code work good...
0
Black Diamond9y ago
string conStringBranchFund = txtpath;
DataTable DataBankfund = new DataTable();
SqlConnection connBranchFund = new SqlConnection(conStringBranchFund);
connBranchFund.Open();
//string query = "select AccountNumberBranch, AccountBank, AccountNumber from AccountNumBranch order by AccountNumber";
string query = "select AccountNumberBranch, AccountBank, AccountNumber from AccountNumBranch order by AccountNumber";
SqlCommand cmd = new SqlCommand(query, connBranchFund);
SqlDataReader reader = cmd.ExecuteReader();
int numRows = 0;
int num = 0;
numRows = DataBankfund.Rows.Count;
for (reader.Read(); num <= numRows; num++)
{
CbBranchFunds.Text = reader.GetString(0) + " (" + reader.GetString(1) + ") " + reader.GetString(2);
}
==============================================================

I have modified my code but this code also display first row only and not autodrop the whole column..
0
Black Diamond9y ago
Hi!

I am not using datagridview, I am using combo box directly read to the database..

Thank you,
0
Rajkiran Swain9y ago
https://www.codeproject.com/Articles/19781/A-data-bound-multi-column-combobox

https://www.intertech.com/Blog/winforms-multi-column-combo-box-in-a-datagridview/
0
Anil Jha9y ago
Try to bind datasource like below.
while (reader.Read())
{

CbBranchFunds.DataSource= reader.GetString(0) + " (" + reader.GetString(1) + ") " + reader.GetString(2);
CbBranchFunds.DataBind();
}
0
Black Diamond9y ago
Yes ! Sir,

You got my point.
My code is only read one row. What I need is to merge the data in every column in one text.
in a combobox and AutoDrop the whole column in a database from first to last.

Thank you.
0
Amit Gupta9y ago
If I understood your question, are you asking to add AccountNumberBranch, AccountBank, AccountNumber to combobox and want to show all these 3 rows all at once to the combobox and display to user?
0