Á¬½Ó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();
Ïà¹ØÎÊ´ð£º
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺
×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏÂ
HTTP Status 500 -
------------------------------------------------------------------------------- ......