中科新闻网吾恩苍白照片:请懂ASP和ASP.Net的帮我做一点小翻译。
来源：百度文库 编辑：中科新闻网 时间：2024/05/16 07:16:27
<%@ Page Language="C#" Debug="true"%>
<%@Import NameSpace="System.Data"%>
<%@Import NameSpace="System.Data.OleDb"%>
<%
string StrCon="Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath("data.mdb");
string strSQL="SELECT * FROM main order by 编号 desc";
OleDbConnection MyConnection=new OleDbConnection(StrCon);
OleDbCommand myCommand=new OleDbCommand(strSQL,MyConnection);
OleDbDataReader myDataReader=null;
myCommand.Connection.Open();
myDataReader=myCommand.ExecuteReader();
myDataReader.Read();
Response.Write("dnews="+myDataReader["新闻"].ToString()); Response.Write("&dtime="+myDataReader["更新时间"].ToString());
myCommand.Connection.Close();
%>
2.将记录些入mdb
<%@ Page Language="C#" Debug="true"%>
<%@Import NameSpace="System.Data"%>
<%@Import NameSpace="System.Data.OleDb"%>
<%
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("data.mdb"));
OleDbCommand myCommand = new OleDbCommand("insert into main (新闻,更新时间) values (" + Request ["addnews"] + ", " + DateTime.Now.ToString() + ")" , myConnection); myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
Response.Write("res=ok");
%>
请参考：
http://www.flashbank.cn/article.asp?id=101
对不起，使我没说清楚，是将下面的ASP.Net翻译成ASP
<%@ Page Language="C#" Debug="true"%>
<%@Import NameSpace="System.Data"%>
<%@Import NameSpace="System.Data.OleDb"%>
<%
string StrCon="Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath("data.mdb"); //建立数据库连接串,此处为OLEDB连接方式,另外还有ado连接方式
string strSQL="SELECT * FROM main order by 编号 desc"; //sql查询,查找所有新闻记录,把它们按编号降序排序.
OleDbConnection MyConnection=new OleDbConnection(StrCon); //建立OLEDB connection连接对象
OleDbCommand myCommand=new OleDbCommand(strSQL,MyConnection); //建立OLEDB command连接对象
OleDbDataReader myDataReader=null; //建立数据读取对象
myCommand.Connection.Open(); //打开connection连接
myDataReader=myCommand.ExecuteReader(); //为数据读取对象建立数据源
myDataReader.Read(); //开始读取数据源
Response.Write("dnews="+myDataReader["新闻"].ToString()); //新闻输出,格式: dnew=新闻内容 &dtime=更新时间
Response.Write("&dtime="+myDataReader["更新时间"].ToString());
myCommand.Connection.Close();//关闭connection连接
%>
2.将记录些入mdb
<%@ Page Language="C#" Debug="true"%>
<%@Import NameSpace="System.Data"%>
<%@Import NameSpace="System.Data.OleDb"%>
<%
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ Server.MapPath("data.mdb")); //同上
OleDbCommand myCommand = new OleDbCommand("insert into main (新闻,更新时间) values (" + Request ["addnews"] + ", " + DateTime.Now.ToString() + ")" , myConnection);//将新闻数据插入表main的"新闻"和"更新时间列"中
myCommand.Connection.Open(); //打开connection连接对象
myCommand.ExecuteNonQuery(); //执行上面的插入语句.
myCommand.Connection.Close(); //同上.
Response.Write("res=ok"); //输出res=ok,插入成功.
%>