|
<% @ Page Language="C#" Debug="True"%>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
public void Page_Load(Object src,EventArgs e)
{
//各种String 的设置
String MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("blog.mdb");
String StrSel1 = "select id,topic,username,addtime from blog";
String StrSel2 = "select USERid,UserName,UserEmail from [user]";
String StrSel3 = "select * from [subject]";
DataSet MyDataSet = new DataSet();
OleDbConnection MyConnection = new OleDbConnection(MyConnString);
//open DataAdapter
OleDbDataAdapter MyAdapter1 = new OleDbDataAdapter(StrSel1,MyConnection);
OleDbDataAdapter MyAdapter2 = new OleDbDataAdapter(StrSel2,MyConnection);
OleDbDataAdapter MyAdapter3 = new OleDbDataAdapter(StrSel3,MyConnection);
//将各表数据存入DataSet
MyAdapter1.Fill(MyDataSet,"blog");
MyAdapter2.Fill(MyDataSet,"user");
MyAdapter3.Fill(MyDataSet,"subject");
//交给DataGrid显示
DataGrid1.DataSource = MyDataSet.Tables["blog"].DefaultView;
DataGrid2.DataSource = MyDataSet.Tables["user"].DefaultView;
DataGrid3.DataSource = MyDataSet.Tables["subject"].DefaultView;
DataGrid1.DataBind();
DataGrid2.DataBind();
DataGrid3.DataBind();
}
</script>
<html>
<head><title>DataSet的使用</title></head>
<body>
<form runat="server">
<ASP:DataGrid id="DataGrid1" runat="server"
AllowPaging="True"
PageSize="5"
PagerStyle-Mode="NumericPages"
BorderColor="black"
BorderWidth="1"
GridLines="Both"
Cellpadding="3"
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
/>
<hr />
<ASP:DataGrid id="DataGrid2" runat="server"
AllowPaging="True"
PageSize="4"
PagerStyle-Mode="NumericPages"
BorderColor="black"
BorderWidth="1"
GridLines="Both"
Cellpadding="3"
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
/>
<hr />
<ASP:DataGrid id="DataGrid3" runat="server"
AllowPaging="True"
PageSize="5"
PagerStyle-Mode="NumericPages"
BorderColor="black"
BorderWidth="1"
GridLines="Both"
Cellpadding="3"
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
/>
</form><p />
</body>
</html>
[C语言系列]c#两种方式 dataset 与byte[] 字节的转换 [C语言系列]NET 中C#的switch语句的语法
[系统软件]托拽Explore中的文件到VB.net的窗口 [系统软件]XPDL学习笔记
[系统软件]Boost库在XP+Visual C++.net中的安装 [常用软件]新配色面板：Paint.Net3.0RC1官方下载
[常用软件]用内建的“Net Meeting”聊天 [VB.NET程序]Henry的VB.NET之旅（三）—共享成员
[VB.NET程序]Henry的VB.NET之旅（二）—构造与析构 [VB.NET程序]Henry的VB.NET之旅（一）—失踪的窗体
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
