Asp.Net查询MSSQL数据库的一个例子
2008-01-05 10:50:46 来源:WEB开发网核心提示:一:使用System.Data.OleDb<%@page language="c#" debug="true"%><%@Import Namespace="System.Data"%><%@Import Namespace=&qu
一:使用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>
- ››asp.net页面弄成伪静态页面
- ››Asp.net 中将汉字转换成拼音的方法
- ››ASP.NET及JS中的cookie基本用法
- ››ASP.NET获取MS SQL Server安装实例
- ››asp.net实现调用百度pai 在线翻译英文转中文
- ››ASP.NET页面选项进行提示判断
- ››Asp.net定时执行程序
- ››查询Oracle正在执行和执行过的SQL语句
- ››ASP.NET中利用DataList实现图片无缝滚动
- ››ASP.NET验证控件RequiredFieldValidator
- ››ASP.NET中使用System.Net.Mail发邮件
- ››ASP.NET中获取用户控件中控件的ID
更多精彩
赞助商链接