Thread: How do I read a CSV into a HTML Table?

1) Load CSV into [2, N] array, or if you're more experienced, an ArrayList of custom structs containing your loaded fields.
2) Build the top of page and opening table.
3) For N, add a row to the table containing the loaded variables (In your array or ArrayList).
4) End the table and build the rest of your page.

I just got it working so I thought I'd share my code.

musicians.aspx

Code:

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="musicians.aspx.cs" Inherits="musicians" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:DataGrid ID="dg" runat="server"></asp:DataGrid>
</asp:Content>

musicians.aspx.cs

Code:

using System;
using System.IO;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class musicians : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        StreamReader SR;
        string S;
        string[] tokens;
        int count = 0;
        SR = File.OpenText("c:\\inetpub\\wwwroot\\musicians");
        DataSet myDataSet = new DataSet();
        DataTable myDataTable = new DataTable();
        
        // Get a Column object
        DataColumn myDataColumn = new DataColumn();
        myDataColumn.DataType = System.Type.GetType("System.String");
        myDataColumn.ColumnName = "Musician";
        myDataColumn.ReadOnly = true;
        myDataColumn.Unique = true;

        // Now add the column to the column collection
        myDataTable.Columns.Add(myDataColumn);

        // Get a Column object
        DataColumn myDataColumn1 = new DataColumn();
        myDataColumn1.DataType = System.Type.GetType("System.String");
        myDataColumn1.ColumnName = "Website";
        myDataColumn1.ReadOnly = true;
        myDataColumn1.Unique = true;

        // Now add the column to the column collection
        myDataTable.Columns.Add(myDataColumn1);

        S=SR.ReadLine();
        while(S!=null)
        {
            tokens = S.Split(new char[] { ',' });
            count++;
            // Instantiate a DataRow object and add it to the Rows collection
            DataRow myDataRow = myDataTable.NewRow();
            myDataRow["Musician"] = tokens[0];
            myDataRow["Website"] = "<a href=\""+tokens[1]+"\" target=\"_blank\">"+tokens[1]+"<a>";

            myDataTable.Rows.Add(myDataRow);
            S=SR.ReadLine();
        }
        myDataSet.Tables.Add(myDataTable);
        dg.DataSource = myDataSet;
        dg.DataBind();
        SR.Close();
    }
}

Im wondering would:


myDataRow["Website"] = "<a href=\""+tokens[1]+"\" target=\"_blank\">"+tokens[1]+"<a>";
Also work by creating a link / linkbutton object, setting all the properties and then call tostring of the link / linkbutton object? At least it would get rid of writing pure html inside your C# code.

Originally Posted by GanglyLamb

Im wondering would:


myDataRow["Website"] = "<a href=\""+tokens[1]+"\" target=\"_blank\">"+tokens[1]+"<a>";
Also work by creating a link / linkbutton object, setting all the properties and then call tostring of the link / linkbutton object? At least it would get rid of writing pure html inside your C# code.

I may have done it wrong, but it didn't work correctly for me.