DataGrid绑定txt文件的例子
ReportFile.txt
姓名,学号,成绩
net_lover,10000,9999999
net_lover,20000,9999999
net_lover,30000,9999999
net_lover,40000,9999999
a.aspx
==============
<%@ Page Language="C#" AutoEventWireup="True" %>
<html>
<head>
<script runat="server">
void Page_Load(Object sender, EventArgs e)
{
string ConnectionString;
string SQLString;
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(".") + ";Extended Properties=\"Text;HDR=yes;FMT=Delimited\"";
SQLString = "Select * from ReportFile.txt";
System.Data.OleDb.OleDbConnection ConnectionText = new System.Data.OleDb.OleDbConnection();
ConnectionText.ConnectionString = ConnectionString;
ConnectionText.Open();
System.Data.OleDb.OleDbDataAdapter AdapterText = new System.Data.OleDb.OleDbDataAdapter(SQLString, ConnectionText);
System.Data.DataSet DataSetText = new System.Data.DataSet("TextFiles");
AdapterText.Fill(DataSetText, "TextFile");
DataGrid1.DataSource = DataSetText;
DataGrid1.DataBind();
ConnectionText.Close();
}
</script>
</head>
<body>
<form runat="server">
<asp:DataGrid id="DataGrid1" runat="server"/>
</form>
</body>
</html>
放在同一文件夹下即可访问
ReportFile.txt
姓名,学号,成绩
net_lover,10000,9999999
net_lover,20000,9999999
net_lover,30000,9999999
net_lover,40000,9999999
a.aspx
==============
<%@ Page Language="C#" AutoEventWireup="True" %>
<html>
<head>
<script runat="server">
void Page_Load(Object sender, EventArgs e)
{
string ConnectionString;
string SQLString;
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(".") + ";Extended Properties=\"Text;HDR=yes;FMT=Delimited\"";
SQLString = "Select * from ReportFile.txt";
System.Data.OleDb.OleDbConnection ConnectionText = new System.Data.OleDb.OleDbConnection();
ConnectionText.ConnectionString = ConnectionString;
ConnectionText.Open();
System.Data.OleDb.OleDbDataAdapter AdapterText = new System.Data.OleDb.OleDbDataAdapter(SQLString, ConnectionText);
System.Data.DataSet DataSetText = new System.Data.DataSet("TextFiles");
AdapterText.Fill(DataSetText, "TextFile");
DataGrid1.DataSource = DataSetText;
DataGrid1.DataBind();
ConnectionText.Close();
}
</script>
</head>
<body>
<form runat="server">
<asp:DataGrid id="DataGrid1" runat="server"/>
</form>
</body>
</html>
放在同一文件夹下即可访问
#region 读取文本文件
string txt = "";
StreamReader sr = new StreamReader(@"E:\test.txt");
while (!sr.EndOfStream)
{
string str = sr.ReadLine();
txt += str + "\n";
}
sr.Close();
Console.Write(txt);
Console.Read();
#endregion