绑定txt文件到DataGrid
来源:互联网 发布:外卖订单打印软件 编辑:程序博客网 时间:2024/06/06 00:49
ReportFile.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();
}
void DG_ItemDataBind(Object sender, DataGridItemEventArgs e)
...{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem )
...{
e.Item.Attributes.Add("title",e.Item.Cells[0].Text);
e.Item.Cells[0].Text = "<a target=_blank href=" + e.Item.Cells[1].Text + ">" + e.Item.Cells[0].Text + "</a>";
}
else
e.Item.Attributes.Add("style","background-color:#dedede");
}
</script>
</head>
<body>
<form runat="server">
<asp:DataGrid id="DataGrid1" runat="server" OnItemDataBound="DG_ItemDataBind" Style="font-size:9pt"/>
</form>
</body>
</html>
<%@ 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();
}
void DG_ItemDataBind(Object sender, DataGridItemEventArgs e)
...{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem )
...{
e.Item.Attributes.Add("title",e.Item.Cells[0].Text);
e.Item.Cells[0].Text = "<a target=_blank href=" + e.Item.Cells[1].Text + ">" + e.Item.Cells[0].Text + "</a>";
}
else
e.Item.Attributes.Add("style","background-color:#dedede");
}
</script>
</head>
<body>
<form runat="server">
<asp:DataGrid id="DataGrid1" runat="server" OnItemDataBound="DG_ItemDataBind" Style="font-size:9pt"/>
</form>
</body>
</html>
- 绑定txt文件到DataGrid
- 绑定txt文件到DataGrid
- 绑定txt文件到DataGrid
- 绑定txt文件到DataGrid
- 绑定txt文件到DataGrid
- 绑定txt文件到DataGrid
- DataGrid读写txt文件
- arrayCollection绑定到DataGrid
- asp.net中将Excel文件(.xls)绑定到DataGrid!
- asp.net中将Excel文件(.xls)绑定到DataGrid!
- DataReader绑定到DataGrid控件
- WPF 绑定DataSet到DataGrid
- DataGrid输出到Word Excel Txt方法
- txt内容显示到datagrid中
- 导出到 txt 文件
- 将某一目录下的所有相同格式的 XML文件绑定到不同的DataGrid
- 某一目录下的所有 XML文件绑定到不同的DataGrid的方法
- 将某一目录下的所有相同格式的 XML文件绑定到不同的DataGrid
- 大型高并发负载网站的系统架构
- 35岁成功人的12条黄金法则
- 带图片的,多列的DropDownList的实现
- 异形数组的生成
- 编译Ethereal On Windows
- 绑定txt文件到DataGrid
- DIM的全称及本来意义
- 数据库的启动与关闭
- DataGrid中过多的文字用省略号表示
- 马云给yahoo员工的演讲——爱迪生欺骗了世界
- 十个本年最炫的WebOS(网络操作系统)点评
- 注册用户时出生日期
- JSF与Struts的异同
- 验证码代码