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

C# ²Ù×÷ACCESSÊý¾Ý¿â

Ô­ÎÄ£ºhttp://www.cnblogs.com/whitetiger/archive/2007/03/27/689620.html
 ÔÚBETA2ÖУ¬¡£NETÌṩÁËÒÔϵÄNAMESPACE£º
System.Data Namespace
System.Data.OleDb £¨ºÍBETA1ÖÐÒѾ­²»Í¬ÁË£¬ËùÒÔÈç¹ûÄÃBETA1ÖеijÌÐòµ½BETA2ÖÐÀ´ÔËÐп϶¨²»¿ÉÒԵģ©
Èç¹ûÏë½²Çå³þÕâЩ¶«Î÷£¬ÎÒ²»ÈÏΪÊÇÎÒ¿ÉÒÔ×÷µ½µÄ£¬ËùÒÔÎÒÏëͨ¹ýһЩ¾ßÌåµÄ³ÌÐòÀ´°ÑÎÒÃǶÔÊý¾Ý¿âµÄ×î»ù±¾µÄ²Ù×÷£¨SELECT¡¢UPDATE¡¢DELETE¡¢INSERTµÈ£©ÑÝʾһÏ£¬ÆäËûµÄ»¹ÊÇÐèÒªÅóÓÑÃÇÔÚѧϰ¹ý³ÌÖÐÀ´ÂýÂýÌå»áÁË£¡
ÒªÏë²Ù×÷Ò»¸öÊý¾Ý¿â£¬²»ÂÛÊÇÄÇÖÖ²Ù×÷£¬Ê×ÏÈÒª×öµÄ¿Ï¶¨ÊÇ´ò¿ªÊý¾Ý¿â£¬ÏÂÃæÎÒÃÇÒÔACCESSÊý¾Ý¿âÀ´×öÀý×Ó˵Ã÷ÈçºÎ´ò¿ªÒ»¸öÊý¾Ý¿âÁ¬½Ó£¡ÔÚÕâÀïÎÒÃÇÐèÒªÓõ½µÄÊÇ£ºSystem.Data.OleDb.OleDbConnectionÀ࣡£¨Èç¹û²Ù×÷SQLÊý¾Ý¿â£¬ÎÒÃÇ×îºÃʹÓÃSystem.Data.SqlClient.SqlConnectionÀࣩ
ÎÒÏÈд³öÎÒ×Ô¼ºÊ¹ÓõijÌÐò£º
using System.Data
using System.Data.OleDb
public OleDbConnection getConn()
{
string connstr="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=F:\\web\\notesbook\\class\\leavenotes.mdb";
OleDbConnection tempconn= new OleDbConnection(connstr);
return(tempconn);
}
ÏàÐÅֻҪʹÓùýADOµÄÅóÓÑÓ¦¸Ã¶¼¿ÉÒÔ¿´¶®µÄ£¡ÎÒÃÇÏȶ¨ÒåÒ»¸öStringÀàÐ͵ıäÁ¿£¬ÆäÖдæ·ÅÁËÎÒÃÇÁ¬½ÓÊý¾Ý¿âµÄÁ¬½Ó×Ö·û´®£¬È»ºóÔÚ¶¨ÒåÒ»¸öSystem.Data.OleDb.OleDbConnectionÀàÐ͵ĶÔÏó²¢ÊµÀý»¯£¬×îºó·µ»ØÕâ¸ö¶ÔÏó£¡ÐèҪ˵Ã÷һϵÄÊÇ£¬ÎÒ²¢Ã»ÓаÑÓï¾ä:tempconn.Open();·Åµ½Õâ¸öº¯ÊýÖУ¬Ô­ÒòÎÒÎÒÉÔºóÔÚ˵Ã÷£¬ÕâÀïÖ»ÊÇÏÈÌáÐÑһϣ¡
ͨ¹ýÉÏÃæµÄº¯Êý£¬ÎÒÃǾÍÒѾ­µÃµ½ÁËÀàËÆÓÚADOÖеÄÁ¬½Ó¶ÔÏóConnectionÁË£¡ÏÂÃæµÄ¾ÍÊǾßÌå²Ù×÷Êý¾Ý¿âÁË£¡
ÔÚ¾ßÌå½²²Ù×÷ǰ£¬ÎÒÈÏΪÓбØÒªÏÈÈÏʶһÏÂÏÂÃæµÄÁ½¸öÀࣺ
System.Data.OleDb.OleDbDataAdapter
System.Data.OleDb.OleDbDataReader
System.Data.OleDb.OleDbDataAdapter£º¿ÉÒÔÖ±½ÓºÍDataSetÁªÏµ£¬²¢²Ù×÷Êý¾ÝÔ´µÄ£¬ËüµÄ¹¦ÄÜÏà¶ÔÇ¿´óһЩ£¬Òò´ËÒ²±È½ÏºÄϵͳ×ÊÔ´£¡
System.Data.OleDb.OleDbDataReader£ºÔòÓÐЩÀàËÆÓÚADOÖеÄÄĸöÖ»¶ÁÏòǰµÄ¼Ç¼¼¯£¬Ëü×î³£ÓÃÔÚÖ»ÐèÒªÒÀ´Î¶ÁÈ¡²¢ÏÔʾÊý¾ÝµÄʱºò£¬Ïà±ÈSystem.Data.OleDb.OleDbDataAdapterÀ´Ëµ£¬ËûºÄÓõÄϵͳ×ÊԴҪС£¡Æäʵ£¬OleDbDataReaderÄÜʵÏֵŦÄÜ£¬OleDbDataAdapter¶¼¿ÉÒÔʵÏÖ£¬²»¹ý´Ó×ÊԴʹÓÃÂʵĽǶȿ¼ÂÇÎÒÃÇÓ¦¸Ã¾¡Á¿Ê¹ÓÃǰÕߣ¡µ«ÓÐЩ¹¦ÄÜ£¬È´ÊDZØÐëʹÓÃOleDbDataAdapter²Å¿ÉÒÔʵÏֵģ¡
* SELECT²Ù×÷£¡
ÏÂ


Ïà¹ØÎĵµ£º

ѧϰasp.net C#

 1¡¢DateTime   Êý×ÖÐÍ  
System.DateTime   currentTime=new   System.DateTime();  
¡¡¡¡1.1   È¡µ±Ç°ÄêÔÂÈÕʱ·ÖÃë  
currentTime=System.DateTime.Now;  
¡¡¡¡1.2   È¡µ±Ç°Äê  
int   Äê=currentTime.Year;  
¡¡¡¡1.3   È¡µ±Ç°Ô &n ......

×ªÔØAccess denied for user

×ªÔØµØÖ·£ºhttp://hi.baidu.com/mbaba/blog/item/39dc8b58d41191dc9c8204c8.html
ºÜ¶àÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâÆªÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡ ......

ÈçºÎ°ÑAccessת³ÉSQL ServerµÄ·½·¨½éÉÜ


ÈçºÎ°ÑAccessת³ÉSQL ServerµÄ·½·¨½éÉÜ
ºÜ¶àÅóÓÑÏëÓÃSQL 2000Êý¾Ý¿âµÄ±à³Ì·½·¨£¬µ«ÊÇÈ´ÓÖ¿àÓÚ×Ô¼ºÊÇѧAccessµÄ£¬¶ÔSQLÖ»ÊÇÒ»µãµãµÄÁË½â¶øÒÑ£¬ÕâÀïÎÒ¸ø´ó¼ÒÌṩÒÔϲο¼---½«Accessת»¯³ÉSQL 2000µÄ·½·¨ºÍ×¢ÒâÊÂÏî¡£Ê×ÏÈ£¬ÎÒ˵µÄÊÇÔÚAccess 2000£¬SQL 2000Ö®¼äת»»£¬ÆäËûµÄÎÒÒ²»¹Ã»Óг¢ÊÔ¹ý£¬Ï£ ......

Data Access Application Block

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 Microsoft.Practices.EnterpriseLibrary.Common;
us ......

C#ºÍJavaScriptµÄ¼òµ¥»¥½»

 
1.asp.netºô½Ðjs
   
                     Response.Write("<script language=javascript>");
              ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ