一:使用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
<titleAsp.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