Populate DataSet from text file

Question

I have text file with log information from another program and it has very bad formatting but I can´t edit original program and I want create a new program with dataGridView which read data from .txt file and add it to datagridview. It´s not so hard and I made it with dataGridView1.Rows.Add and array of strings (and prepared columns before). But I don´t use datasource and dataset. I want to add filtering (combobox in header of datagridview, like here but I can´t add it without dataset. So how can I create dataset with just array of strings which has just data? I am trying this code:

DataSet ds = new DataSet();
ds.Tables.Add(TableName);
ds.Tables[TableName].Columns.Add("Datum");
ds.Tables[TableName].Columns.Add("Cas");
ds.Tables[TableName].Columns.Add("Moduly");

Then I read everyline in file and create array with strings and try add that array to row:

ds.Tables[TableName].Rows.Add(PoleRetezcu);

And then just add DataSet do datagridview but it wont work:

dataGridView1.DataSource = ds;

Thank you for help

DataGridView doesnt have DataBind() method or maybe I am wrong but I can´t use this method. — Libor Zapletal
Sorry, getting muddled between windows and web. I haven't had any experience with the DataGridView. — Andy Rose

Pat Pat · Accepted Answer · 2010-09-29T22:26:33

You can probably skip the DataSet creation altogether and use the DataGridView's own methods to add the data, as is done in this MSDN example. Particularly, look at step 4, which has the following code:

private void PopulateDataGridView()
{

    string[] row0 = { "11/22/1968", "29", "Revolution 9", 
        "Beatles", "The Beatles [White Album]" };
    string[] row1 = { "1960", "6", "Fools Rush In", 
        "Frank Sinatra", "Nice 'N' Easy" };
    string[] row2 = { "11/11/1971", "1", "One of These Days", 
        "Pink Floyd", "Meddle" };
    string[] row3 = { "1988", "7", "Where Is My Mind?", 
        "Pixies", "Surfer Rosa" };
    string[] row4 = { "5/1981", "9", "Can't Find My Mind", 
        "Cramps", "Psychedelic Jungle" };
    string[] row5 = { "6/10/2003", "13", 
        "Scatterbrain. (As Dead As Leaves.)", 
        "Radiohead", "Hail to the Thief" };
    string[] row6 = { "6/30/1992", "3", "Dress", "P J Harvey", "Dry" };

    songsDataGridView.Rows.Add(row0);
    songsDataGridView.Rows.Add(row1);
    songsDataGridView.Rows.Add(row2);
    songsDataGridView.Rows.Add(row3);
    songsDataGridView.Rows.Add(row4);
    songsDataGridView.Rows.Add(row5);
    songsDataGridView.Rows.Add(row6);

    songsDataGridView.Columns[0].DisplayIndex = 3;
    songsDataGridView.Columns[1].DisplayIndex = 4;
    songsDataGridView.Columns[2].DisplayIndex = 0;
    songsDataGridView.Columns[3].DisplayIndex = 1;
    songsDataGridView.Columns[4].DisplayIndex = 2;
}

(By the way, you can bind a DGV to a DataTable directly - you don't need a DataSet to track it. This article basically shows how to do that.)

Hope that helps. Post your final answer ;-)

Populate DataSet from text file

2 Answers