Á¬½ÓaccessµÄÆæ¹ÖÎÊÌâ
×¢²á»áÔ±³É¹¦ÁË£¬Êý¾Ý¿âÒ²ÓÐÁË£¬È»ºóÎÒÓÃ×¢²áµÄÓû§µÇ¼£¬Ö»Óд洢Êý¾Ý¿â×îºóÒ»ÌõÊý¾ÝÄܵǼ£¬ÆäÓà¶¼²»ÄܵǼʲôÔÒò
û¿´µ½ÄãµÄ´úÂë²»ÖªµÀ£¡£è£å£è£å
Ìù´úÂë³öÀ´¿´¿´°É!!!!
Äǿ϶¨ÊÇÄãµÄ´úÂëµÄÔÒò£¬ÄãʹÓÃÁËÓ²±àÂëÁ˰ɣ¿
°ÑÄãµÄµÇ¼²¿·Ö´úÂëÌùÉÏÀ´¿´¿´¡£
string usname = null;
string psw = null;
string role = "";
string conString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=aa.mdb";
OleDbConnection conn = new OleDbConnection(conString);
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "select username,[password],role from [user]";
OleDbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
usname = rdr["username"].ToString();
psw = rdr["password"].ToString();
Ïà¹ØÎÊ´ð£º
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......
ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pa ......