How to merge or combine two combobox in one comb box

ahmed salah

9y1.9kVisual Basic .NET

I have two combo box controls

First combo box show Arabic membership

Second combo box show English member ship

I need to merge two combo box in one combo box show both of them

my code as below

MemberAR sheet and MemberEN sheet have two fields

MemberID , MemberName

public DataTable ShowExcelDataArabic()
{
OleDbConnection con = new OleDbConnection(connection);
con.Open();
string str = "select * from [MemberAR$]";
OleDbCommand com = new OleDbCommand();
com = new OleDbCommand(str, con);
OleDbDataAdapter oledbda = new OleDbDataAdapter();
oledbda = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
ds = new DataSet();
oledbda.Fill(ds, "[MemberAR$]");
con.Close();
DataTable dt = new DataTable();
dt = ds.Tables["[MemberAR$]"];
return dt;
}
public DataTable ShowExcelDataEnglish()
{
OleDbConnection con = new OleDbConnection(connection);
con.Open();
string str = "select * from [MemberEN$]";
OleDbCommand com = new OleDbCommand();
com = new OleDbCommand(str, con);
OleDbDataAdapter oledbda = new OleDbDataAdapter();
oledbda = new OleDbDataAdapter(com);
DataSet ds = new DataSet();
ds = new DataSet();
oledbda.Fill(ds, "[MemberEN$]");
con.Close();
DataTable dt = new DataTable();
dt = ds.Tables["[MemberEN$]"];
return dt;
}

in load event of windows form

combo box Arabic membership and combo box English member ship as following :

QrClasses qrc = new QrClasses();
DataTable dt = qrc.ShowExcelDataArabic();
int c = 0;
comboBox1.Items.Insert(0, "???? ?????");
comboBox1.SelectedIndex = 0;
for (c = 0; c <= dt.Rows.Count - 1; c++)
{
comboBox1.Items.Add(dt.Rows[c].ItemArray[1]);
}
DataTable dt2 = qrc.ShowExcelDataEnglish();
int d = 0;
comboBox2.Items.Insert(0, "Select Member");
comboBox2.SelectedIndex = 0;
for (d = 0; d <= dt2.Rows.Count - 1; d++)
{
comboBox2.Items.Add(dt2.Rows[d].ItemArray[1]);
}

5 Replies

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

Amit Gupta9y ago
Try this
var dt = new DataTable (); // your data table
for (int x =0; x
{
    var row = dt.Rows [x];
    Combobox.Items.Add ($"{row.ItemArray [1]} - {row.ItemArray [2]}");
}
Please mark as answer, if it solves your issue. Thanks!
0
ahmed salah9y ago
YES
I need to combine two fields separated by (-)

in sheet i have 3 column

MemberID MemberNameAR , MemberNameEN

I need to select values of MemberNameAR , MemberNameEN in combobox
in one line
suppose i have in excel sheet as following :

MemberID MemberNameAR MemberNameEN
1 way visitor
2 train partner

in combo box data i need will display as below

way - visitor
train - partner
0
Amit Gupta9y ago
@Ahmed

It could me helpful, if you clarify your requirement properly.

Do you want to show 3 items (member,partner, part) in a combobox?
0
ahmed salah9y ago
Thank you for reply

actually what i need is to make as following

remove two sheets and create new sheet

as sheet1

and sheet1 contain following fields

MemberID MemberNameAR MemberNameEN

and in combo box i need the result as below
member - ?????
Partner-?????
part-???
so that my problem i face it

How to join two fields in combo box ?
meaning i need combo box result
display member contain two fields
MemberNameAR - MemberNameEN
0
Amit Gupta9y ago
@Ahmed

As you are using DataTable, you can bind there data using DataSource property instead of looping though each row, like
DataTable dt = qrc.ShowExcelDataArabic();
Combobox1.DataSource = dt
Combobox1.DisplayMemberPath = "MemberName"; // column to display
Coming to your question, merging items of both the combobox to one.
DataTable dt = qrc.ShowExcelDataArabic();
DataTable dt2 = qrc.ShowExcelDataEnglish();
//Merging data tables
dt.Merge(dt2);
Combobox1.DataSource = dt
Combobox1.DisplayMemberPath = "MemberName";
That's all you have to do!!
0