How to read values from datatable into listview?

[WSDeveloper]

please see the picture, I want to show records in listview as they are saved in table.
but with below code it is reading group ids only and showing this in a single line.

  SqlDataAdapter dataAdap = new SqlDataAdapter(sqlcmd);

            DataTable data = new DataTable();
            dataAdap.Fill(data);
            if (data.Rows.Count > 0)
            {
                //---------------------------------

                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());
                        // item.Text = row[i].ToString();
                    }
                    listView1.Items.Add(item);
                }

                //------------------------

 

[Skydiver]

Without seeing what your sqlcmd looks like, it'll be very hard to help you. What if the sqlcmd has a TOP 1 or a WHERE clause that selects just one item from the database?

 

[jmcilhinney]

Why use a ListView in the first place? It's not a grid control. Use a DataGridView.