Trying to populate ListView from MS Access database

Question

I am trying to create a method that returns all the data of a column so that data can be used on a listview to populate it.

    public static Array populatelistview()
{
    OleDbConnection myConnection = GetConnection();
    string query = "SELECT * FROM trainlines_"; 
    OleDbCommand command = new OleDbCommand(query, myConnection); 
    command.Connection = myConnection;

    DataSet trainlinedata = new DataSet();
    trainlinedata.Clear();
    OleDbDataAdapter datareader = new OleDbDataAdapter(command);
    datareader.Fill(trainlinedata);
    myConnection.Close();
    return trainlinedata;
}

Answer 1

You should return DataSet Type not Array.Because trainlinedata is declare as DataSet

public static DataSet populatelistview()
{
    OleDbConnection myConnection = GetConnection();
    string query = "SELECT * FROM trainlines_"; 
    OleDbCommand command = new OleDbCommand(query, myConnection); 
    command.Connection = myConnection; 
    DataSet trainlinedata = new DataSet();
    OleDbDataAdapter datareader = new OleDbDataAdapter(command);
    datareader.Fill(trainlinedata);
    myConnection.Close();
    return trainlinedata;
}