Remove From My Forums

How do I add a DataTable to a ListView?

Question

Consider this code:

 public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            addData();
        }

        public void addData()
        {        
            DataTable dt = new DataTable();
            dt.Columns.Add("Column 1");
            dt.Columns.Add("Column 2");
            dt.Rows.Add(new object[] { "Dummy", "Data"});
            dataGridView1.DataSource = dt;
        }
    }

If I would do the same with a ListView, and add the same data to it, how would I go about to do that?
"listView1.DataSource" doesn't seem to work.

Monday, February 29, 2016 3:50 PM

Answers

The obvious way to go is datagridview, but you can build a listview as explained here:

http://stackoverflow.com/questions/4592430/is-there-an-easy-way-to-populate-a-listview-by-a-datatable

// Clear the ListView control
            listView1.Items.Clear();
            int ColCount = dtable.Columns.Count;
            //Add columns
            for (int k = 0; k < ColCount; k++)
            {
               listView1.Columns.Add(dtable.Columns[k].ColumnName);
            }
            // Display items in the ListView control
            for (int i = 0; i < dtable.Rows.Count; i++)
            {
                DataRow drow = dtable.Rows[i];

                // Only row that have not been deleted
                if (drow.RowState != DataRowState.Deleted)
                {
                    // Define the list items
                    ListViewItem lvi = new ListViewItem(drow[0].ToString());
                    for (int j = 1; j < ColCount; j++)
                    {
                        lvi.SubItems.Add(drow[j].ToString());                        
                    }
                    // Add the list items to the ListView
                    listView1.Items.Add(lvi);
                }
            }

Hope that helps.

Technet articles: WPF: Layout Lab; All my Technet Articles

Proposed as answer by Moonlight ShengMicrosoft contingent staff Friday, March 4, 2016 8:55 AM
Marked as answer by Moonlight ShengMicrosoft contingent staff Monday, March 7, 2016 8:45 AM

Monday, February 29, 2016 8:31 PM

Answered by:

How do I add a DataTable to a ListView?

Question

Answers