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#´úÂëÀï½øÐе÷ÓÃ,´«Èë²ÎÊý,µÃµ½²éѯºóµÄ½á¹û¼¯~¾ÍÊÇÏëʵÏÖÕâ¸ö¹¦ÄÜ,¿ÉÊÇ´úÂë²»ÖªµÀÔõôд Çë´óÏÀÃǸøÖ¸µãÖ¸µãßÂ~ÒýÓà string strSql = "select * from tb where name = '" + this.textBox.text + "'" ÏëÕâÑù£¿ ´óÏÀÃÇ,¸Õ²ÅµÄÎÊÌâÄã¿ÉÄÜûÀí½âÎÒµÄÒâ˼,ÎÒµÄÒâ˼ÊÇ: ÎÒÔÚACCESSÊý¾Ý¿âÀïÒѾ½¨Á¢ÁËÒ»¸ö´ø²ÎÊýµÄ²éѯ(ÀàËÆSqlServerµÄ´æ´¢¹ý³Ì)
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ ±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿ <%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤? ÄãÊÇÔõÑù¸³ÖµµÄ£¿ ²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO; using Syst ......
ÓÃ"·þÎñÆ÷¿Ø¼þÃû.Style.Add("display","")¿ÉÒÔ¸øÕâ¿Ø¼þÌí¼ÓCSS£¬ÔõôÑù²ÅÄܸø¶Á³öÀ´ÄØ£¿ Ôõô¶¼Ã»È˰ïæ°¡ È˶¼ËÀÄÄÈ¥ÁË ¿Ø¼þID.Style[HtmlTextWriterStyle.BackgroundColor] ¿Ø¼þ ......