Á¬½Ó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 £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......