C# datatable to listview

Question

I like to be able to view datatable in windows form

I managed to get the headers only with ListView how to get the data in there

DataTable data = new DataTable();

data = EnumServices();

//create headers
foreach (DataColumn column in data.Columns)
{
      listView_Services.Columns.Add(column.ColumnName);
}

I just want to show now the data in there!

cheers

Answer 1

foreach (DataRow row in data.Rows)
{
    ListViewItem item = new ListViewItem(row[0].ToString());
    for (int i = 1; i < data.Columns.Count; i++)
    {
        item.SubItems.Add(row[i].ToString());
    }
    listView_Services.Items.Add(item);
}

Update: also, if you're calling your method more than once, you need to either clear the columns collection before adding the columns, or check to see if the columns have already been added - otherwise, the number of columns will keep increasing every time you call your method.

Answer 2

I've been looking for solution to this but I failed. I wasn't able to find any that would best answer to this problem, so I made my own solution. I am so much glad that I was able to make this solution as shorter, easier and more understandable yet would best answer to what most of us looking for.

    public void ShowCurrentParked()
    {
        dt3 = new DataTable();

        dt3.Clear();    //clear to avoid overlapping data (new DataTable is not enough)

        lstViewShowCurrentParked.Items.Clear();  //clear items to accept new or updated data to avoid overlapping/duplicate data

        dt3 = pBAL.ShowCurrentParked();  //datasource (class)
        for (int j = 0; j < dt3.Rows.Count; j++)
        {
            lstViewShowCurrentParked.BeginUpdate();
            lstViewShowCurrentParked.Items.Add(new ListViewItem(new string[] {dt3.Rows[j][1].ToString(),dt3.Rows[j][2].ToString(),
        dt3.Rows[j][3].ToString()}));
        }

        lstViewShowCurrentParked.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
        lstViewShowCurrentParked.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);

        lstViewShowCurrentParked.EndUpdate();

        dt3.Clear();   //clear again to avoid overlapping data (new DataTable is not enough) .. to make datatable really empty


        //BeginUpdate and EndUpdate will just lessen the flicker during listview update
    }

Efficiency: 1. fast 2. avoid data duplication 3. less flicker