¼±£¡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Êý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40
ÇëÎÊÎ ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
ÎÒ²éѯaccess£¨97£©µÄʱºòÀÏÊÇÌáʾ²ÎÊý²»×㣬µ«ÊÇÎÒÔÚaccess²éѯÕâÌõÓï¾äÊÇûÓдíÎóµÄ¡£ÊÇÔõô»ØÊÂÄØ£¿
SQL code:
SELECT * from wcj WHERE Pno = '3' And TRim(Conclusion) = 'ºÏ¸ñ' and (NET) is null
S ......