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

accessÊÂÎñ²åÈë¶àÌõ¼Ç¼

protected void Button1_Click(object sender, EventArgs e)
    {
        /*=============²âÊÔͨ¹ý===============*/
       
OleDbConnection con = new
OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data
Source=C:/Inetpub/wwwroot/DotNetArticle/App_Data/DotNetArticle.mdb");
        con.Open(); 
        OleDbCommand cmd = new OleDbCommand();
        cmd.Connection = con;
        cmd.Transaction = con.BeginTransaction();
        try
        {
            string sql1 = "insert into teaminfo (num,username,isplay) values(1,'a',1)";
            string sql2 = "insert into teaminfo (num,username,isplay) values(2,'b',1)";
            string sql3 = "insert into teaminfo (num,username,isplay) values(3,'c',1)";
            string[] SQLStringList = { sql1, sql2, sql3 };
            for (int n = 0; n < SQLStringList.Length; n++)
            {
                string strsql = SQLStringList[n].ToString();
                if (strsql.Trim().Length > 1)
                {
                   


Ïà¹ØÎĵµ£º

access ÈÕÆÚ²Ù×÷С½á

ÁгöijһÌì, ÉÏÒ»ÐÇÆÚµÄÊý¾Ý
SELECT distinct dateandtime
from ctdate_by_query_date
WHERE dateandtime between ((#2006-5-15#+(Weekday(2006-5-15)-7))-6) and (#2006-5-15#-7)+Weekday(2006-5-15)
sql="SELECT distinct dateandtime from ctarticle WHERE dateandtime between ((#"&date&"#+(We ......

AccessÖÐ"ÊÇ/·ñ"Êý¾ÝÀàÐÍÊÇÔõÑù´¦ÀíµÄ

¼ÙÉèNews±íÖÐÓÐÒ»¸öÊôÐÔPassed£¬Êý¾ÝÀàÐÍÊÇ“ÊÇ/·ñ“
1,¶Á²Ù×÷£ºstring str="select * from News where Passed=True";(access)¶Á“ÊÇ“²Ù×÷¡£
string str="select * from News where Passed=False";(access)¶Á“·ñ“²Ù×÷¡£
2,д²Ù×÷£º
string str="Delete from News wher ......

ʲôÊÇAccessÊý¾Ý¿â

 Microsoft AccessÊÇÒ»ÖÖ¹ØÏµÊ½Êý¾Ý¿â£¬¹ØÏµÊ½Êý¾Ý¿âÓÉһϵÁбí×é³É£¬±íÓÖÓÉһϵÁÐÐкÍÁÐ×é³É£¬Ã¿Ò»ÐÐÊÇÒ»¸ö¼Ç¼£¬Ã¿Ò»ÁÐÊÇÒ»¸ö×ֶΣ¬Ã¿¸ö×Ö¶ÎÓÐÒ»¸ö×Ö¶ÎÃû£¬×Ö¶ÎÃûÔÚÒ»¸ö±íÖв»ÄÜÖØ¸´¡£ ¡¡¡¡
±íÓë±íÖ®¼ä¿ÉÒÔ½¨Á¢¹ØÏµ£¨»ò³Æ¹ØÁª£¬Á¬½Ó£©£¬ÒÔ±ã²éѯÏà¹ØÁªµÄÐÅÏ¢¡£AccessÊý¾Ý¿âÒÔÎļþÐÎʽ±£´æ£¬ÎļþµÄÀ©Õ¹ÃûMDB¡£ ¡¡¡¡ ......

SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»

 ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾ ......

ºÜÍ·ÌÛµÄACCESS²éѯÎÊÌ⣡

ÔÚACCESS(2007)Êý¾Ý¿âÖУ¬ÓÐÕâÑùÒ»¸öÄ£ºý²éѯ£¬ 
select postId,postName,postType,left(postTime,10) as postTimes from PostInfo where postUser like '*ÖÜ·¼*'
ÔÚÊý¾Ý¿â²éѯºó½á¹ûÏÔʾÕýÈ·£¬¿ÉÊÇ·ÅÔÚÏîÄ¿µÄ´úÂëÖУ¬¾ÓÈ»²»ÏÔʾ²éѯµÄ½á¹û¿©¡£¼ì²éÁ˰ëÌ춼ûÓз¢ÏÖ´íÎóÔÚÄÄÀ×îºó²ÅÖªµÀ£¬ÓеÄACCESS¾ÓÈ»²»ÈÏʶͨŠ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ