当前页面: 开发资料首页 → J2SE 专题 → Asp.Net查询MSSQL数据库的一个例子
Asp.Net查询MSSQL数据库的一个例子
摘要: 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>
<head>
</head>
<body>
<form runat="server">
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"/>
pageSize="5"
pagerStyle-mode="NumericPages"/>
pageSize="5"
pagerStyle-mode="NumericPages"/>
</form>
</body>
二:使用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">
</form>
<table width="96%"> <tr> <td background="http:///images/dian.gif" height="3"></td> </tr> </table>
↑返回目录
前一篇: 在Oracle中存取BLOB对象实现文件的上传和下载
后一篇: 增强的Windows窗体为.Net程序丰富用户界面