How to load data from database into listview in C#

Try This



private void ListView(DataSet _DataSet)

{

    DataTable dtable = _DataSet.Tables["table_name"];

    listView1.Items.Clear();

    for (int i = 0; i < dtable.Rows.Count; i++)

    {

        DataRow drow = dtable.Rows[i];

         if (drow.RowState != DataRowState.Deleted)

        {

            ListViewItem lvi = new ListViewItem(drow["column1"].ToString());

            lvi.SubItems.Add (drow["column2"].ToString());

            lvi.SubItems.Add (drow["column3"].ToString());

            lvi.SubItems.Add (drow["column4"].ToString());

             listView1.Items.Add(lvi);

        }

    }

}

Saranya Boopathi