C# Winforms Bind ListBox to DataTable Issue

Question

Well, I've ran into a problem when binding ListBox control to DataTable.

Code:

using (DbWrapper db = DbFactory.GetConnection("SQLite").WrapIn<MyDbWrapper>())
{
    db.Open();

    DataTable results = db.ExecuteQuery("SELECT id,title FROM schedule");

    ScheduleList.DataSource = results;
    ScheduleList.DisplayMember = "title";
    ScheduleList.ValueMember = "id";
}

This code is supposed to receive data from my SQLite database, and bind it to my ScheduleList, but when I compile I see my ListBox filled with System.Data.DataRowView strings.

enter image description here

There's no problems with database. The application is receiving data, and the data is correct. If I iterate through my datatable I will get id and title as column names, so theres nothing wrong with them.

I've read that the problem may be solved by changing binding order or setting ListBox.Sorted property to false. I've tried it all and still no success.

Any suggestions? Are there any other solutions except iterating over datarows and adding them manually?

Best Regards.

Possible duplicate of: stackoverflow.com/questions/8803859/… — DonBoitnott
– DonBoitnott, Commented May 30, 2013 at 13:39
Well, it is, but solutions posted there didn't solve my problem. — fakemeta
– fakemeta, Commented May 30, 2013 at 13:41

Emmanouil Chountasis · Accepted Answer · 2013-05-30 17:14:28Z

4

I used this code and it worked.

DataTable oTable = new DataTable();
oTable.Columns.Add("ID", typeof(int));
oTable.Columns.Add("TITLE", typeof(string));

DataRow oNewRow = null;
for (int i = 0; i < 10; i++) 
{
    oNewRow = oTable.NewRow();

    oNewRow["ID"] = i;
    oNewRow["TITLE"] = "Title_" + i.ToString();

    oTable.Rows.Add(oNewRow);
}

listBox1.DataSource = oTable;
listBox1.ValueMember = "ID";
listBox1.DisplayMember = "TITLE";

enter image description here

EDIT: you may need to give tha datasource first and then declare the value-display members.

answered May 30, 2013 at 17:14

Emmanouil Chountasis

5901 gold badge7 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

fakemeta Over a year ago

Thank you for your effort, but I've already fixed the problem. It was caused by custom DrawItem event.

DonBoitnott · Accepted Answer · 2013-05-30 13:50:55Z

0

Rearrange the statements:

ScheduleList.DisplayMember = "title";
ScheduleList.ValueMember = "id";
ScheduleList.DataSource = results;

answered May 30, 2013 at 13:50

DonBoitnott

11.1k7 gold badges53 silver badges70 bronze badges

Comments

fakemeta · Accepted Answer · 2013-05-30 14:25:12Z

0

My bad. The ListBox wasn't reacting to DisplayMember and ValueMember changes because of inappropriate code in custom ListBox DrawItem event.

answered May 30, 2013 at 14:25

fakemeta

1,0181 gold badge9 silver badges22 bronze badges

1 Comment

DonBoitnott Over a year ago

I suspected something like that because my testing, and indeed every search result I found, suggested the code you had ought be working well.

Collectives™ on Stack Overflow

C# Winforms Bind ListBox to DataTable Issue

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related