asp.net Êý¾Ý¿âÁ¬½ÓÎÊÌ⣡ - .NET¼¼Êõ / ASP.NET

ÕâÊDzÙ×÷´úÂ룺
string strsql = "select * from user where UserID=4445";

  string dbpath = Server.MapPath("App_Data/cnhww.mdb");
  string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbpath + ";User Id=;Password=;";
  OleDbConnection objConnection = new OleDbConnection(strConnection);
  objConnection.Open();

  OleDbCommand objCommand = new OleDbCommand(strsql, objConnection);
  OleDbDataReader dr = objCommand.ExecuteReader();

  if (dr.Read())
  {
  Response.Write(dr["UserName"].ToString());
  }
  dr.Close();

  objConnection.Close();


ÒÔÏÂÊÇ´íÎóÐÅÏ¢£º
from ×Ó¾äÓï·¨´íÎó¡£
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆڼ䣬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£

Òì³£ÏêϸÐÅÏ¢: System.Data.OleDb.OleDbException: from ×Ó¾äÓï·¨´íÎó¡£

Ô´´íÎó:

---

´ó¸ç̫ллÄãÁË£¬ÖÕÓÚ½â¾öÁËÒ®¡£Ð¡µÜÎÒÕæÐĵĸÐлÄ㣡

---

Êý¾Ý¿â¹Ø¼ü×Ö ÒªºÃºÃѧѧ~£¡ ¿ÉÒÔÓÃuser ¼Ó[]¾Í¿ÉÒÔÁË

---

ÒýÓÃ

select * from user where UserID=4445 °ÑÄãµÄ±íÃû¸Äһϣ¬¸Ä³Éɶ¶¼ÐУ¬Ö»Òª²»ÊÇuser¡£ÒòΪuserÊǹؼü×Ö¡£

²»ÓøıíÃû£¬¼Ó[]£¬
BatchFile code

---

Code highlighting produced by Actipro C