C# ÈçºÎµ÷ÓÃACCESSÖдø²ÎÊýµÄ²éѯ ¾´ÇëÖ¸½Ì
ÈçºÎÔÚC#Öе÷Óôø²ÎÊýµÄACCESS²éѯ???½ô¼±Çó¾È°¡~~~
²éѯÒѾ½¨ºÃÁË:
PARAMETERS RepDay DateTime;
SELECT ... from ... WHERE ReportDay = RepDay;
Çë¸÷λ´óÏÀ²»ÁߴͽÌ~~~~~~
ÔÚÏßµÈ
string strSql = "select * from tb where name = '" + this.textBox.text + "'"
ÏëÕâÑù£¿
²»Ã÷°×ÄãµÄÒâ˼Ŷ
°ï¶¥
ÏÈÒýÓÃaccessÊý¾Ý¿âµÄÃüÃû¿Õ¼ä
È»ºóÁ¬½ÓÊý¾Ý¿â
½øÐвéѯßÂ
´óÏÀÃÇ,¸Õ²ÅµÄÎÊÌâÄã¿ÉÄÜûÀí½âÎÒµÄÒâ˼,ÎÒµÄÒâ˼ÊÇ:
ÎÒÔÚACCESSÊý¾Ý¿âÀïÒѾ½¨Á¢ÁËÒ»¸ö´ø²ÎÊýµÄ²éѯ(ÀàËÆSqlServerµÄ´æ´¢¹ý³Ì),È»ºóÎÒÒªÔÚC#´úÂëÀï½øÐе÷ÓÃ,´«Èë²ÎÊý,µÃµ½²éѯºóµÄ½á¹û¼¯~¾ÍÊÇÏëʵÏÖÕâ¸ö¹¦ÄÜ,¿ÉÊÇ´úÂë²»ÖªµÀÔõôд
Çë´óÏÀÃǸøÖ¸µãÖ¸µãßÂ~
´óÏÀÃÇ,¸Õ²ÅµÄÎÊÌâÄã¿ÉÄÜûÀí½âÎÒµÄÒâ˼,ÎÒµÄÒâ˼ÊÇ:
ÎÒÔÚACCESSÊý¾Ý¿âÀïÒѾ½¨Á¢ÁËÒ»¸ö´ø²ÎÊýµÄ²éѯ(ÀàËÆSqlServerµÄ´æ´¢¹ý³Ì),È»ºóÎÒÒªÔÚC#´úÂëÀï½øÐе÷ÓÃ,´«Èë²ÎÊý,µÃµ½²éѯºóµÄ½á¹û¼¯~¾ÍÊÇÏëʵÏÖÕâ¸ö¹¦ÄÜ,¿ÉÊÇ´úÂë²»ÖªµÀÔõôд
Çë´óÏÀÃǸøÖ¸µãÖ¸µãßÂ~
´óÏÀÃÇ,¸Õ²ÅµÄÎÊÌâÄã¿ÉÄÜûÀí½âÎÒµÄÒâ˼,ÎÒµÄÒâ˼ÊÇ:
ÎÒÔÚACCESSÊý¾Ý¿âÀïÒѾ½¨Á¢ÁËÒ»¸ö´ø²ÎÊýµÄ²éѯ(ÀàËÆSqlServerµÄ´æ´¢¹ý³Ì)
Ïà¹ØÎÊ´ð£º
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡
www.51aspx.com
ȥϠ......
ÎÒÕâÀïÓÐÒ»¸öµÇ½WIFIÍøÂçµÄÒ³Ãæ¡£ÓÉÓÚWIFI¾³£¶ÏÏߣ¬ËùÒÔÒª·´¸´µØÔÚÕâ¸öÍøÒ³Éϵǽ£¬Ã»·¨ÎÞÈËÖµÊØ¡£
ËùÒÔ£¬ÎÒÏë×öÒ»¸öC#³ÌÐò£¬·ÅÒ»¸öwebbrowser¿Ø¼þ£¬×Ô¶¯Ìî±í²¢×Ô¶¯µã»÷Ìá½»°´Å¥¡£
ÎÊÌâÒ»£º
»ù±¾ÕÕÍøÉÏÕҵijÌÐò ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......