■■第一次做数据库连接，不知如何实现ASP的rs("XX")■■

minghui000 2004-05-03 04:07:27

<%@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#。。。谢谢大家！！！帮个忙，做个好心！！：）

...全文

205 16 点赞打赏收藏举报

写回复

16 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

wanjinbao 2004-05-06

在给你一些经典的链接方式：
SQL Server
ODBC

Standard Security:
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"

Trusted connection:
"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"

Prompt for username and password:
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"

OLEDB, OleDbConnection (.NET)

Standard Security:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

Trusted Connection:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Prompt for username and password:
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"

Connect via an IP address:
"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
SqlConnection (.NET)

Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
Declare the SqlConnection:

C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open();

VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open()

Data Shape

MS Data Shape
"Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog=pubs;User ID=sa;Password=asdasd;"

打赏
举报

回复赞

minghui000 2004-05-06

楼上答得好。。分规你！！我就喜欢你这样负责任的人

打赏
举报

回复赞

nowfox 2004-05-05

Conn.Open();
OleDbCommand Comm=new OleDbCommand("Select * from ebooks",Conn);
OleDbDataReader rs=Comm.ExecuteReader();
while(rs.Read())
{
……
……
Response.Write(rs["UserName"].ToString());
……
……
}

打赏
举报

回复赞

minghui000 2004-05-05

有时候新东西不一定比旧东西好。。我喜欢用 rs[]

打赏
举报

回复赞

DB牛牛 2004-05-05

在rs.item[1]的后面加上.value
rs.item[1].value 写成这样就可以了

打赏
举报

回复赞

lxcc 2004-05-05

干吗不用ADO.NET和datagrid

<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">

void Page_Load(object sender, EventArgs e) {

if (!Page.IsPostBack) {

// Databind the data grid on the first request only
// (on postback, rebind only in paging command)

BindGrid();
}
}

void DataGrid_Page(object sender, DataGridPageChangedEventArgs e) {

DataGrid1.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}

void BindGrid() {

// TODO: update the ConnectionString and CommandText values for your application
string ConnectionString = "server=(local);database=pubs;trusted_connection=true";
string CommandText = "select au_lname, au_fname, address, city, state from Authors order by au_lname";

SqlConnection myConnection = new SqlConnection(ConnectionString);
SqlDataAdapter myCommand = new SqlDataAdapter(CommandText, myConnection);

DataSet ds = new DataSet();
myCommand.Fill(ds);

DataGrid1.DataSource = ds;
DataGrid1.DataBind();
}

</script>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
<h2>Data Report with Paging
</h2>
<hr size="1" />
<form runat="server">
<asp:datagrid id="DataGrid1" runat="server" AllowPaging="true" PageSize="6" OnPageIndexChanged="DataGrid_Page" ForeColor="Black" BackColor="White" CellPadding="3" GridLines="None" CellSpacing="1" width="80%">
<HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle>
<PagerStyle horizontalalign="Right" backcolor="#C6C3C6" mode="NumericPages"></PagerStyle>
<ItemStyle backcolor="#DEDFDE"></ItemStyle>
</asp:datagrid>
</form>
</body>
</html>