一:使用system.data.oledb
<%@page language="c#" debug="true"%>
<%@import namespace="system.data"%>
<%@import namespace="system.data.oledb"%>
<script language="c#" runat="server">
public void page_load(object o,eventargs e)
{
/**定义相关变量*/
string strconn="provider=sqloledb.1;data source=localhost;initial catalog=pubs;user id=sa;password=lzjliu202080";
string strsql1="select * from authors";
string strsql2="select * from jobs";
string strsql3="select * from sales";
/**建立数据库连接*/
oledbconnection myconn=new oledbconnection(strconn);
try
{
/**查询数据*/
oledbdataadapter myadapter1=new oledbdataadapter(strsql1,myconn);
oledbdataadapter myadapter2=new oledbdataadapter(strsql2,myconn);
oledbdataadapter myadapter3=new oledbdataadapter(strsql3,myconn);
/**实例化dataset*/
dataset mydata=new dataset();
/**将数据资料存入dataset*/
myadapter1.fill(mydata,"authors");
myadapter2.fill(mydata,"jobs");
myadapter3.fill(mydata,"sales");
/**设置数据来源*/
mygrid1.datasource=mydata.tables["authors"].defaultview;
mygrid2.datasource=mydata.tables["jobs"].defaultview;
mygrid3.datasource=mydata.tables["sales"].defaultview;
/**数据绑定*/
mygrid1.databind();
mygrid2.databind();
mygrid3.databind();
}
catch(exception ex)
{
response.write("应用程序发生意外错误!");
}
finally
{
/**资源释放*/
//myadapter1.close();
//myadapter2.close();
//myadapter3.close();
myconn.close();
}
}
</script>
<html>
<head>
<title>asp.net数据查询</title>
</head>
<body>
<form runat="server">
<asp:datagrid id="mygrid1" runat="server"
allowpaging="true"
pagesize="5"
pagerstyle-mode="numericpages"
bordercolor="black"
borderwidth="1"
cellpadding="3"
cellspacing="0"
gridlines="both"
font-name="verdana"
font-size="8pt"
headerstyle-backcolor="#aaaadd"
alternatingitemstyle-backcolor="#eeeeee"/>
<asp:datagrid id="mygrid2" runat="server"
allowpaging="true"
pagesize="5"
pagerstyle-mode="numericpages"/>
<asp:datagrid id="mygrid3" runat="server"
allowpaging="true"
pagesize="5"
pagerstyle-mode="numericpages"/>
</form>
</body>
</html>
二:使用system.data.sqlclient
<%@page language="c#" debug="true"%>
<%@import namespace="system.data"%>
<%@import namespace="system.data.sqlclient"%>
<script language="c#" runat="server">
protected void page_load(object o,eventargs e)
{
/**变量定义*/
string strconn="server=localhost;database=pubs;user=sa;password=lzjliu202080";
string strsql1="select * from authors";
string strsql2="select * from jobs";
string strsql3="select * from sales";
/**建立数据库连接*/
sqlconnection dbconn=new sqlconnection(strconn);
/**查询资料*/
sqldataadapter myadapter1=new sqldataadapter(strsql1,dbconn);
sqldataadapter myadapter2=new sqldataadapter(strsql2,dbconn);
sqldataadapter myadapter3=new sqldataadapter(strsql3,dbconn);
/**实例化dataset*/
dataset mydata=new dataset();
/**将资料存入dataset*/
myadapter1.fill(mydata,"author");
myadapter2.fill(mydata,"job");
myadapter3.fill(mydata,"sale");
/**设置数据源*/
grid1.datasource=mydata.tables["author"].defaultview;
grid2.datasource=mydata.tables["job"].defaultview;
grid3.datasource=mydata.tables["sale"].defaultview;
/**数据显示*/
grid1.databind();
grid2.databind();
grid3.databind();
}
</script>
<form name="form1" runat="server">
<asp:datagrid id="grid1" runat="server"
font-size="12px"/>
<asp:datagrid id="grid2" runat="server"
font-size="12px"/>
<asp:datagrid id="grid3" runat="server"
font-size="12px"/>
</form>
闽公网安备 35060202000074号