■■第一次做数据库连接,不知如何实现ASP的rs("XX")■■
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
<%@Page Language="C#" debug=true runat=server%>
<script runat=server>
void Page_Load(Object sender,EventArgs e){
}
</script>
<%
OleDbConnection Conn=new OleDbConnection();
//得到web.config中数据库的完整路径
Conn.ConnectionString=ConfigurationSettings.AppSettings["databaseconn"] + Server.MapPath(ConfigurationSettings.AppSettings["databasepath"]);
//Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+Server.MapPath("db1.mdb");
Conn.Open();
OleDbCommand Comm=new OleDbCommand("Select * from ebooks",Conn);
OleDbDataReader rs=Comm.ExecuteReader();
%>
<table border="1" width="72%" cellspacing="0" cellpadding="0" bordercolor="#008000">
<tr>
<td>ID</td>
<td>姓名</td>
<td>标题</td>
<td>时间</td>
<td>删除</td>
</tr>
<tr>
<td> <%Response.Write(rs["user"]);%></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
//要求用C#。。。谢谢大家!!!帮个忙,做个好心!! :)