Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼±£¡vs2005 accessÊý¾ÝµÄ²éѯÎÊÌâ

string shuju = "SELECT ÈÕÆÚ from ²úÆ·³µ¼äÈÕ±¨±í" + shijian + " where (»úºÅ=@»úºÅ)";
OleDbCommand oledbcmd = new OleDbCommand(shuju, oledbcon);
        oledbcmd.Parameters.Add("@»úºÅ", OleDbType.Integer).Value = eee;
OleDbDataAdapter olesda = new OleDbDataAdapter(oledbcmd);
×ÜÊDzéѯ²»µ½Êý¾Ý
C# code:
//ÕâÀïÖ±½ÓÓÃÎʺÅ
string shuju = "SELECT ÈÕÆÚ from ²úÆ·³µ¼äÈÕ±¨±í" + shijian + " where (»úºÅ=?)";
OleDbCommand oledbcmd = new OleDbCommand(shuju, oledbcon);
oledbcmd.Parameters.Add("@»úºÅ", OleDbType.Integer).Value = eee;
OleDbDataAdapter olesda = new OleDbDataAdapter(oledbcmd);



Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

aspÍøÒ³ÏòaccessÊý¾Ý¿â²åÈë ÈÕÆÚÀàÐÍÎÊÌâ(¸ßÊÖ½ø)

ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.  
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40 
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40  
ÇëÎÊÎ ......

ÈçºÎ½«accessÀïÃæµÄ¸½¼þ±£´æµ½´ÅÅÌÉÏÄØ

Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit

ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......

dwr Illegal access to default constructor´íÎó

dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
  <param name="formBean" value="prisonerForm"/>
  < ......

²éѯaccessµÄÀÏÊÇÌáʾ²ÎÊý²»×ã

ÎÒ²éѯaccess£¨97£©µÄʱºòÀÏÊÇÌáʾ²ÎÊý²»×㣬µ«ÊÇÎÒÔÚaccess²éѯÕâÌõÓï¾äÊÇûÓдíÎóµÄ¡£ÊÇÔõô»ØÊÂÄØ£¿
SQL code:
SELECT * from wcj WHERE Pno = '3' And TRim(Conclusion) = 'ºÏ¸ñ' and (NET) is null

S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ