public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db1.mdb");
string strSQL = "SELECT * FROM lcd_name"; OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);
OleDbDataReader datareader = null;
myConn.Open();
datareader = myCmd.ExecuteReader();
while (datareader.Read()) // 如果没有该while循环则无法读取数据
{
Response.Write datareader["pzq_name"].ToString();
Response.Write datareader["pzq_linenum"].ToString();
}
myConn.Close();
}
{
protected void Page_Load(object sender, EventArgs e)
{
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db1.mdb");
string strSQL = "SELECT * FROM lcd_name"; OleDbConnection myConn = new OleDbConnection(strDSN);
OleDbCommand myCmd = new OleDbCommand(strSQL, myConn);
OleDbDataReader datareader = null;
myConn.Open();
datareader = myCmd.ExecuteReader();
while (datareader.Read()) // 如果没有该while循环则无法读取数据
{
Response.Write datareader["pzq_name"].ToString();
Response.Write datareader["pzq_linenum"].ToString();
}
myConn.Close();
}
Response.Write datareader["pzq_linenum"].ToString();
是不是pzq_name或pzq_linenum 为空,ToString(); 出错?
在web.config中...value的值应该是 "~/db1.mdb" 还是"~\db1.mdb" 如果数据库是在文件夹里面..就得再加上上一个文件夹的名字 如~/123/db1.mdb
public static OleDbConnection Connection
{
get
{ string address = System.Web.HttpContext.Current.Server.MapPath("~/App_Data/DataBaseName;");
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + address;
if (con == null)
{
con = new OleDbConnection(connectionString);
con.Open();
}
else if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}
else if (con.State == System.Data.ConnectionState.Broken)
{
con.Close();
con.Open();
}
return con;
}
}
这个是可以用的,我现在用的就是这个。
我用
response.write datareader.getstring(0)可以得到数据
是不是vs2005不能用下面这条语句了
Response.Write datareader["pzq_name"].ToString();