Geek asks and answers

Fill a list or list from datatable (window form)

I am trying to populate a list or list from a database using C #. I use datatable to collect data. I am using this code below. But listview or listbox populate something like text "System.Data.DataRow". Where I have something else in my database. Please, help

query = "select itemtag from tbl_inventory order by itemtag";
DataTable dt = con.DataTable(query);
int count = dt.Rows.Count;
if (count >0)
{
    //listView1.Items.Clear();
    listBox1.Items.Clear();

    for (int i = 0; i < count; i++)
    {
        //listView1.Items.Add(dt);
        listBox1.Items.Add(dt.Rows[i].ToString());
    }
}

As you see I am getting output like "System.Data.DataRow"where I have something else in my database

Any help?

+3
source share
4 answers

If you use a list, then directly use the DATASOURCE ... property.

ListBox1.DataSource
+3
source

If your DataTable is 1-dimensional (in this case, why are you using a DataTable), then your code should be:

listBox1.Items.Add(dt.Rows[i][columnIndexHere].ToString());
+2
source 
 listBox1.Items.Add(dt.Rows[i][0].ToString());

listview. subitem, .

 ListItem li = listBox1.Items.Add(dt.Rows[i][0].ToString());
 li.SubItems.Add(dt.Rows[i][1].ToString());
 li.SubItems.Add(dt.Rows[i][2].ToString());
0

listBox1.Items.Add(dt.Rows[i][0]+"|"+dt.Rows[i][1] +"vs" + dt.Rows[i][3]);
0
source

More articles:


All Articles