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²Ù×÷£¡
ÏÂ
Ïà¹ØÎĵµ£º
תÔصØÖ·£ºhttp://hi.baidu.com/mbaba/blog/item/39dc8b58d41191dc9c8204c8.html
ºÜ¶àÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâƪÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡ ......
Private Sub cmdListProperties_Click()
ListControlProps Me
End Sub
Public Sub ListControlProps(ByRef frm As Form)
Dim ctl As Control
Dim prp As Property
On Error GoTo props_err
For Each ctl In ......
ÖíÄêÎÞÁÄ,¸ÄÁËÒ»¸ö´úÂ룬ÓеãD°æÄǸöÒâ˼£¬°ÑWAP PUSHµÄC#´úÂë¸Äµ½ÁËJAVA
ÔÀ´³ö´¦£º
http://www.codeproject.com/cs/internet/wappush.asp
¸Ä¹ýºóµÄ´úÂëÔÚÏÂÃ棬³ÌÐòºÃÏñ¿ÉÒÔÊä³öÁËWAPPUSHµÄ½á¹¹»¯µÄ¶«Î÷£¬µ«ÊÇ£¬Ã»ÓÐÔÚCMPPÐÒéÉϲâÊÔͨ¹ý¡£
¹²7¸öÎļþ£º
package com.wap.wbxml;
public class Runner {
&nbs ......
1¡¢ÎÊÌâÃèÊö£ºÓÃVBA°ÑÊý¾Ý´ÓExcelµ¼Èëµ½Access£¨ÏµÍ³°æ±¾ºÅ£ºMicrosoft Windows XP Professional °æ±¾ 2002 Service Pack 3£»Office Access°æ±¾ºÅ£º2002/XP£©¡£
´úÂëÃèÊö£ºInsert Into [±íÃû]([×Ö¶Î1],[×Ö¶Î2]) " & _
&n ......
1.asp.netºô½Ðjs
Response.Write("<script language=javascript>");
......