How You can Use CSV File as Data Source of Gridview

HTML clipboard

Here I will show how you can use csv file as data source of gridview.

Demo.csv file
firstname,lastname
hiren,soni
kirtan,patel
sanjay,parmar
ghanu,nayak

Output:

image.gif

Code and explanation:

        //  get all lines of csv file
        string[] str = File.ReadAllLines(Server.MapPath("demo.csv"));

        // create new datatable
        DataTable dt = new DataTable();

        // get the column header means first line
        string[] temp = str[0].Split(',');

        // creates columns of gridview as per the header name
        foreach(string t in temp)
        {
          dt.Columns.Add( t , typeof(string));
        }

         // now retrive the record from second line and add it to datatable
        for(int i=1;i<str.Length;i++)
        {
            string[] t = str[i].Split(',');
            dt.Rows.Add(t);

        }

        // assign gridview datasource property by datatable
        GridView1.DataSource = dt;

        // bind the gridview
        GridView1.DataBind();


Hope you understand it.

Thank You.


Similar Articles