Asp.Net学习笔记:使用DataSet

最新推荐文章于 2019-04-02 16:29:07 发布

k98188

最新推荐文章于 2019-04-02 16:29:07 发布

阅读量652

点赞数

分类专栏： asp.net 文章标签： dataset asp.net datagrid string server asp

本文链接：https://blog.csdn.net/k98188/article/details/192032

版权

asp.net 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

<% @ Page Language="C#" Debug="True"%>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>

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>