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

asp.netÁ´½ÓAccessÊý¾Ý¿â×Ö·û´®ÕýÈ··½·¨

ÔÚweb  configÖР ×÷ÈçÏÂÅäÖãº
<connectionStrings>
    <add name="ydycon" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=|DataDirectory|ydy.mdb" providerName="System.Data.OleDb"/>
 
  </connectionStrings>
ÔÚ.netÎļþÖÐÓ¦ÓÃÁ´½Ó×Ö·û´®£º
 
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;  //Ìí¼ÓÒýÓÃ
using System.Text;
using System.IO;
using System.Collections;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
     // string ConStr = "Server=(./SQLEXPRESS);DataBase=|Datadrictory|db_17.mdf;Uid=;Pwd=";
            string cmdtxt = "SELECT * from tb_13";
            OleDbConnection Con = new OleDbConnection(System.Configuration .ConfigurationManager.ConnectionStrings ["ydycon"].ToString() );
            //OleDbConnection Con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("ydy.mdb"));
           // SqlConnection Con = new SqlConnection(ConStr);
            Con.Open();
            OleDbDataAdapter da = new OleDbDataAdapter(cmdtxt, Con);
           // SqlDataAdapter da = new SqlDataAdapter(cmdtxt, Co


Ïà¹ØÎĵµ£º

AccessºÍSQL2000ÖÐÓï¾äµÄÇø±ð

1 £¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
access±íʾΪ£º#1981-28-12#
SQLSERVER2000±íʾΪ£º''1981-02-12''
2,SQLÓï¾äÇø±ð£¬select ,update ÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUpdateÓï¾ä¶Ô±È:
SQLSERVERÖиüжà±íµÄUpdateÓï¾ä:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......

Access ÀàÐÍת»»º¯Êý

 Ç°ÑÔ
    ×î½üÒ»Ö±ÔÚ×öAccessÊý¾Ýµ¼ÈëOracleµÄÒ»¸ö³ÌÐò£¬¾¡¹ÜÏîÄ¿ÒѾ­Íê³É£¬µ«ÊÇÓÐʱҲ»áÓöµ½ÎÊÌ⣬×îÖ÷Òª»¹ÊǶÔAccess²»ÊìϤµÄÔ­Òò£¬ÌرðÊÇÀàÐÍת»»£¬¶øÕâ¸öÊÇÎÒÕâ¸öÏîÄ¿ÖÐÒ»¶¨»áÓöµ½µÄ¡£ËùÒÔ¿´µ½ÕâÑùһƪÎÄÕÂͦºÃµÄ£¬¾Íת¹ýÀ´ÁË¡£
תÌùµØÖ·£ºhttp://www.cnblogs.com/wf225/archive/2008/10/09/130 ......

macÀí½âMedia Access Control½éÖÊ·ÃÎÊ¿ØÖÆ

 Ã½Ìå½ÓÈë¿ØÖÆ²ãµÄËõд
ʲôÊÇmac!!!
Èç¹ûÄãÊÇͨ¹ýÐ£Ô°Íø»òÐ¡Çø½ÓÈëInternet£¬ÄÇôһ¶¨Ìý˵¹ýMACµØÖ·¡£Ê²Ã´ÊÇMACµØÖ·£¬MACµØÖ·ÔÚÕâÖÖ¾ÖÓòÍø»·¾³Öо¿¾¹Æðµ½Ê²Ã´×÷Óã¿ÏÂÃæ¾ÍÀ´½éÉÜÒ»ÏÂMACµØÖ·µÄ֪ʶ£¬MACµØÖ·ºÍIPµØÖ·µÄÇø±ðÒÔ¼°MACµØÖ·ÔÚʵ¼ÊÓ¦ÓÃÖÐËùÉæ¼°µ½µÄ°²È«ÎÊÌâ¡£
¡¡¡¡Ò»¡¢»ù´¡ÖªÊ¶
¡¡¡¡Èç½ñµÄÍøÂçÊÇ·Ö²ãÀ´Êµ ......

½â¾öSQL ServerתACCESS×Ô¶¯±àºÅÎÊÌâ


1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......

ͨ¹ý ADO.NET ±à¼­ Access Êý¾Ý¿â

·¢²¼ÈÕÆÚ : 8/8/2003 | ¸üÐÂÈÕÆÚ : 6/7/2004
Martin Tracy
Visual Studio Team
Microsoft Corporation
ÊÊÓÃÓÚ£º Microsoft® ADO.NET
Microsoft® ASP.NET
Microsoft® Visual C#® .NET
Microsoft® Visual Studio® .NET
ÕªÒª£º±¾ÑÝÁ·ËµÃ÷ÁËÈçºÎʹÓüòµ¥µÄ Visual C#® ÄÚº¬´úÂë Web Ó¦ÓÃ³Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ