Asp.Net查询MSSQL数据库的一个例子
一:使用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>