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();
}
}