如:
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中我该如何实现呢?
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中我该如何实现呢?
<%@ 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>
"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();
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();
}请大侠再看看,正解后结帖,谢谢!!
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;详细和程序没有经过测试,楼主自己测一下吧!
我万份感激!!我网上找了半天没有好源码
rs(“”)=dr【“”】。tostring()
如果显示的是表就用dataset或者datagrid等控件,循环中的rs(“”)就用他
<@#DataBinder.Eval(Container.DataItem,"字段名"%>