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; " +
Ïà¹ØÎĵµ£º
JavaÅàѵ¿Î³ÌÖ®Êý¾Ý¿â¼¼Êõѧϰ
¿´µ½ºÜ¶à³õѧÕß·´¸´ÎÊÕâ¸öÎÊÌ⣬дÁËÒ»¸öºÜ¼òµ¥µÄÒ»¸ö½Å±¾£¬ÓÃÓÚ×Ô¶¯ÉèÖû·¾³±äÁ¿¡£°Ñ´úÂ뿽±´£¬Áí´æÎªjavaEnv.bat¡£°²×°ÍêJava 2 SDKÖ®ºó£¬¿ªÒ»¸öÃüÁîÐд°¿Ú,ÊäÈëjavaEnv java2SDKDir(java2SDKDirÊÇÄãµÄjavaµÄ°²×°Ä¿Â¼£¬²»´ ......
ϵͳ»·¾³£ºwindows xp
Èí¼þ»·¾³£ºC£«£« builder 6.0
±¾´ÎÄ¿µÄ£ºÍê³ÉÒ»¸ö¼òÒ×È´²»Ê§»ªÀöµÄ½øÏú´æ¹ÜÀíϵͳ¡£
ÕâÊǰëÄêǰ×÷µÄÒ»¸ö¿Î³ÌÉè¼Æ£¬ÓõÄBCB+ACCESSÊý¾Ý¿âÍê³ÉµÄ£¬½çÃæÃÀ»¯ÊÇÓõÄBusinessSkinForm5.25ºº»¯°æ£¬ËüÊÇBCBµÄµÚÈý·½¿Ø¼þ£¬Ê¹ÓñȽϷ½±ã£¬ÍøÉÏÓкܶàÌׯ¤·ô¿É¹©Ï ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
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Êý¾Ýµ¼ÈëOracleµÄÒ»¸ö³ÌÐò£¬¾¡¹ÜÏîÄ¿ÒѾÍê³É£¬µ«ÊÇÓÐʱҲ»áÓöµ½ÎÊÌ⣬×îÖ÷Òª»¹ÊǶÔAccess²»ÊìϤµÄÔÒò£¬ÌرðÊÇÀàÐÍת»»£¬¶øÕâ¸öÊÇÎÒÕâ¸öÏîÄ¿ÖÐÒ»¶¨»áÓöµ½µÄ¡£ËùÒÔ¿´µ½ÕâÑùһƪÎÄÕÂͦºÃµÄ£¬¾Íת¹ýÀ´ÁË¡£
תÌùµØÖ·£ºhttp://www.cnblogs.com/wf225/archive/2008/10/09/130 ......