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: http://stackoverflow.com/questions/8803859/how-to-bind-a-listbox-to-a-datatable-from-a-session-object — DonBoitnott, May 30 '13 at 13:39
Well, it is, but solutions posted there didn't solve my problem. — fakemeta, May 30 '13 at 13:41

score 4 · Answer 1 · answered May 30 '13 at 17:14

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.

Thank you for your effort, but I've already fixed the problem. It was caused by custom DrawItem event. — fakemeta, May 31 '13 at 08:22

score 0 · Answer 2 · answered May 30 '13 at 13:50

0

Rearrange the statements:

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

answered May 30 '13 at 13:50

DonBoitnott

10,787
6
49
68

score 0 · Accepted Answer · answered May 30 '13 at 14:25

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 '13 at 14:25

fakemeta

938
1
8
21

I suspected something like that because my testing, and indeed every search result I found, suggested the code you had ought be working well. – DonBoitnott May 30 '13 at 17:15

C# Winforms Bind ListBox to DataTable Issue

3 Answers3