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

ASP.NETµÄACCESSÊý¾Ý¿â²Ù×÷Àà

//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ· 
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ· 
/// 
/// È¡µÃdataset 
// 
/// ²éѯÓï¾ä 
/// 
public DataSet GetDataSet(string Commandtext) 

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " + 
"Data Source=" + Server.MapPath(datapatch); 
string strCommandText = Commandtext; 
OleDbConnection myConnection = new OleDbConnection(strConnection); 
myConnection.Open(); 
OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText,myConnection); 
OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater); 
DataSet myDataset = new DataSet(); 
myAdpater.Fill(myDataset); 
myConnection.Close(); 
return myDataset; 

/// 
/// È¡µÃ±í 
/// 
/// ²éѯÓï¾ä 
/// 
public DataTable GetDataTable(string Commandtext) 

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " + 
"Data Source=" + Server.MapPath(datapatch); 
string strCommandText =Commandtext; 
OleDbConnection myConnection = new OleDbConnection(strConnection); 
myConnection.Open(); 
OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText,myConnection); 
OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater); 
DataSet myDataset = new DataSet(); 
myAdpater.Fill(myDataset); 
DataTable mytable = myDataset.Tables[0]; 
myConnection.Close(); 
return mytable; 

/// 
/// È¡µÃijÐеÄijÁеÄÖµ 
/// 
/// ÁеÄÃû³Æ 
/// ËùÊô±íÃû 
/// ±íµÄÖ÷¼ü 
/// ÁÐËùÊôµÄÖ÷¼üÖµ 
/// 
public string GetDataColum(string strColumnName,string strTableName,string strColumnkey,string strColumnValue) 

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " +


Ïà¹ØÎĵµ£º

ΪaccessÊý¾Ý¿â´´½¨ÓµÓв»Í¬·ÃÎÊȨÏÞµÄÓû§

      JavaÅàѵ¿Î³ÌÖ®Êý¾Ý¿â¼¼Êõѧϰ
      ¿´µ½ºÜ¶à³õѧÕß·´¸´ÎÊÕâ¸öÎÊÌ⣬дÁËÒ»¸öºÜ¼òµ¥µÄÒ»¸ö½Å±¾£¬ÓÃÓÚ×Ô¶¯ÉèÖû·¾³±äÁ¿¡£°Ñ´úÂ뿽±´£¬Áí´æÎªjavaEnv.bat¡£°²×°ÍêJava 2 SDKÖ®ºó£¬¿ªÒ»¸öÃüÁîÐд°¿Ú,ÊäÈëjavaEnv java2SDKDir(java2SDKDirÊÇÄãµÄjavaµÄ°²×°Ä¿Â¼£¬²»´ ......

¼òÒ×È´²»Ê§»ªÀö [½øÏú´æ¹ÜÀí£Ý(BCB+ACCESS)

ϵͳ»·¾³£ºwindows xp
Èí¼þ»·¾³£ºC£«£« builder 6.0
±¾´ÎÄ¿µÄ£ºÍê³ÉÒ»¸ö¼òÒ×È´²»Ê§»ªÀöµÄ½øÏú´æ¹ÜÀíϵͳ¡£
        ÕâÊǰëÄêǰ×÷µÄÒ»¸ö¿Î³ÌÉè¼Æ£¬ÓõÄBCB+ACCESSÊý¾Ý¿âÍê³ÉµÄ£¬½çÃæÃÀ»¯ÊÇÓõÄBusinessSkinForm5.25ºº»¯°æ£¬ËüÊÇBCBµÄµÚÈý·½¿Ø¼þ£¬Ê¹ÓñȽϷ½±ã£¬ÍøÉÏÓкܶàÌׯ¤·ô¿É¹©Ï ......

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

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

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ