aspx_beginners thread: Re: Populate a listview with a dataset.
Jonas,
I think you might try the following
using System.Data.OleDb;
OleDbConnection dbConn = new OleDbConnection();
OleDbCommand dbCmd = new OleDbCommand();
dbConn.ConnectionString = sConn;
dbConn.Open();
//need a select string here
dbLocalCmd.CommandText=sSQL;
dbCmd.Connection = dbConn;
This gets away from a fixed dataset control.
With the resulting
OleDbDataReader rsLocal = dbLocalCmd.ExecuteReader();
while (rsLocal.Read())
you can then add the rsLocal items to the listview.
including the headers etc