高分求解，如何在asp.net中实现象在asp中RecordSet的功能

[zfs5220]

如：
asp
..............
set rs = server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if password <> rs("password") then
...
sql = "select * form A where ClassID='"&rs(ClassID)&"'"
...

在asp.net中我该如何实现呢？

[zfs5220]

如何绑定到DataList控件呢？

我写了如下的代码，但是不行

public void BindDataBind(){

string ConnectString = @"provider=Microsoft.Jet.OLEDB.4.0;data source=E:\aspnet\aspnettest\MyBook\MyBook.mdb";

string sqlString = "select * From MyBookInfo";

OleDbConnection myConnection = new OleDbConnection(ConnectString);
OleDbCommand sqlSelectRs = new OleDbCommand(sqlString,myConnection);
myConnection.Open();
OleDbDataReader reader = sqlSelectRs.ExecuteReader();
while(reader.Read())
{
if (reader["title"].ToString() == "标题5")
{
showInfo.DataSource = reader;
}
}
showInfo.DataBind();
}

请大侠再看看，正解后结帖，谢谢！！

[zfs5220]

自己顶下~~

[oldmoon]

public void BindDataBind(){

string ConnectString = @"provider=Microsoft.Jet.OLEDB.4.0;data source=E:\aspnet\aspnettest\MyBook\MyBook.mdb";

string sqlString = "select * From MyBookInfo";

OleDbConnection myConnection = new OleDbConnection(ConnectString);
//OleDbCommand sqlSelectRs = new OleDbCommand(sqlString,myConnection);
myConnection.Open();
//OleDbDataReader reader = sqlSelectRs.ExecuteReader();
OleDbDataAdapter da=new OleDbDataAdapter(sqlString,,myConnection);
DataSet ds=new DataSet();
da.Fill(ds,"MyBookInfo");

showInfo.DataSource = Ds;

showInfo.DataBind();
}

注意绑定要用OleDbDataAdapter;详细和程序没有经过测试,楼主自己测一下吧!

[oldmoon]

还要注意前台<@#DataBinder.Eval(Container.DataItem,"字段名"%>

[zfs5220]

to: oldmoon(浪者)

没有下面的条件了，我要取出数据库里标题是“标题5”的记录，然后绑定到DataList

reader["title"].ToString() == "标题5"

[vesaa]

给你个建议, 不要把asp.net类比成asp来学习, 虽然你会觉得这样更容易学会.net但是最终.你是要吃大亏的. 我以前也是搞asp的,后来转.net的时候的想法和你现在一样,看个.net代码就想弄成和asp的一样,方便自己看,这样下去,就会在.net上走弯路了. 失去面向对象的意义了, 你还是弄个简单的代码看看,照着代码学, 彻底丢掉asp. 听我的没错的.(我现在都忘了asp怎么写了,哈哈)

[zfs5220]

vesaa() ,谢谢

那位兄弟有较好的asp.net源码的，给我一份（ [e-mail] ）
我万份感激！！我网上找了半天没有好源码

[vesaa]

我有简单得,呵呵,要不要?? 基本上涵盖了.net得所有知识面.你照着学学就ok了.

怎么给你???

顺便给点分呗,嘿嘿.

[levin9]

用sqldatareader。
rs（“”）＝dr【“”】。tostring（）
如果显示的是表就用dataset或者datagrid等控件，循环中的rs（“”）就用他
<@#DataBinder.Eval(Container.DataItem,"字段名"%>

[zfs5220]

to: vesaa()

发到我的E-mail：[e-mail]

谢谢！！

[debug1984]

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

// Insert page code here
//
void Page_Load(Object src,EventArgs e){
if(!Page.IsPostBack){
string strpath=Server.MapPath("zhxv2.mdb");
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+="Data Source="+@strpath;

OleDbConnection conn=new OleDbConnection(strConnection);
string cmdstr="select top 1 * from userinfo";
OleDbCommand olecmd=new OleDbCommand(cmdstr,conn);
conn.Open();
OleDbDataReader reader=olecmd.ExecuteReader();
reader.Read();
//
if(pwd.Text!=reader["pwd"].ToString()){
sql = "select * form A where ClassID='"+reader["classID"].ToString()+"'"
}
reader.Close();
conn.Close();
}

}

</script>

[time_is_life]

OleDbConnection nwindConn = new OleDbConnection("Provider=MSDataShape;Data Provider=SQLOLEDB;" +
"Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind");

OleDbCommand custCMD = new OleDbCommand("SHAPE {SELECT CustomerID, CompanyName FROM Customers} " +
" APPEND ({SELECT CustomerID, OrderID FROM Orders} AS CustomerOrders " +
" RELATE CustomerID TO CustomerID)", nwindConn);
nwindConn.Open();

OleDbDataReader custReader = custCMD.ExecuteReader();
OleDbDataReader orderReader;

while (custReader.Read())
{
Console.WriteLine("Orders for " + custReader.GetString(1));
// custReader.GetString(1) = CompanyName

orderReader = (OleDbDataReader)custReader.GetValue(2);
// custReader.GetValue(2) = Orders chapter as DataReader

while (orderReader.Read())
Console.WriteLine("\t" + orderReader.GetInt32(1));
// orderReader.GetInt32(1) = OrderID
orderReader.Close();
}

custReader.Close();
nwindConn.Close();