📄 datareader.aspx
字号:
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<Script Language="C#" Runat="Server">
OleDbDataReader dr;
public void Page_Load(Object src,EventArgs e)
{
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\db1.mdb;";
string strSel = "Select * from BookMark";
OleDbConnection MyConn = new OleDbConnection(MyConnString);
OleDbCommand MyComm = new OleDbCommand(strSel,MyConn);
MyComm.Connection.Open();
dr = MyComm.ExecuteReader();
}
</script>
<html>
<font size="-1">
<head>
<title></title>
</head>
<body>
<b>DataReader实例</b>
<table border=2>
<tr bgcolor="#aaaadd"><td>姓名</td><td>性别</td><td>兴趣</td></tr>
<%
while(dr.Read())
{
%>
<tr><td><%=dr["name"]%></td><td><%=dr["sex"].ToString()%></td><td><%=dr["interests"].ToString()%></td></tr>
<% }
dr.Close();
%>
</table>
</body>
</font>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -