转:http://space.itpub.net/28861/viewspace-235726
aspx:
<asp:GridView ID="dgData" runat="server" AutoGenerateColumns="True" CellPadding="4"
ForeColor="Black" GridLines="Vertical" BackColor="White" BorderColor="#DEDFDE"
BorderStyle="None" BorderWidth="1px" Width="80%"
Font-Names="Arial" Font-Size="8pt" Visible=false ShowHeader="false">
<FooterStyle BackColor="#E6EAF7" />
<RowStyle BackColor="#E6EAF7" />
<SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<HeaderStyle BackColor="LemonChiffon" Font-Bold="True" ForeColor="#666699" HorizontalAlign="Left" BorderColor="DeepSkyBlue" />
<AlternatingRowStyle BackColor="White" />
<PagerSettings Visible="False" />
</asp:GridView>
cs:
private void ImportCSVToDS()
{
int intColCount = 0;
bool blnFlag = true;
DataTable mydt = new DataTable("myTableName");
DataColumn mydc;
DataRow mydr;
string strpath = "D://ManifestItems20080409.txt";
//string strpath = Server.MapPath("test" + "/" + a.csv);
string strline;
string [] aryline;
System.IO.StreamReader mysr = new System.IO.StreamReader(strpath);
while((strline = mysr.ReadLine()) != null)
{
aryline = strline.Split(',');
if (blnFlag)
{
blnFlag = false;
intColCount = aryline.Length;
for (int i = 0; i < aryline.Length; i++)
{
mydc = new DataColumn(aryline[i]);
mydc.ColumnName=i.ToString();
mydt.Columns.Add(mydc);
}
}
mydr = mydt.NewRow();
for (int i = 0; i < intColCount; i++)
{
mydr[i] = aryline[i];
}
mydt.Rows.Add(mydr);
}
dgData.DataSource =mydt;
dgData.DataBind();
}