AccessÊý¾Ý¿âÔÚC#.netϵĴ洢·¾¶ÎÊÌâ
¼´Ê¹ÎÒ½«Êý¾Ý¿â·ÅÔÚÏîÄ¿ÄÚ½¨µÄÎļþ¼ÐdbÏ£¬¿ÉÊǽøÐд洢²Ù×÷µÄʱºò£¬Êý¾Ý±íûÓÐÈκα仯¡£ºóÀ´·¢ÏÖ´¢´æ¸Ä±ä·¢ÉúÔÚbin\\debug\\dbĿ¼ÏµÄÊý¾Ý¿âÖУ¬Õâ¸öÊý¾Ý¿âÊÇÔÚ³ÌÐòÔËÐÐʱ×Ô¶¯¸´ÖƹýÈ¥µÄ£¬¿ÉÊÇΪʲô´æ´¢±ä»¯Ã»Óз´Ó¦µ½ÍâÃæÏîÄ¿ÄÚµÄÊý¾Ý¿âdbÏÂÄØ£¿ÎÒÏëÁ¬½Ó×Ö·û´®ÖÐdatasourceÖеÄdatadirectory´æÔÚһЩÐþ»ú£¬ÓÚÊÇÎÒÕÒµ½Ò»¸ö¸Ä±ä´æ´¢Â·¾¶µÄ·½·¨£¬ÒÔʵÏÖ¶ÔÊý¾Ý¿â²Ù×÷ÄÜÂäʵµ½ÄãÖ¸¶¨µÄÏîÄ¿Êý¾Ý¿âÎļþÖС£
//¸Ä±äÊý¾Ý¿â´æ´¢Â·¾¶
¡¡¡¡ string p = AppDomain.CurrentDomain.BaseDirectory;//»ñÈ¡²Ù×÷µÄÖ±½Ó·¾¶
¡¡¡¡ //ÖØÐ¶¨Î»Êý¾Ý¿â
¡¡¡¡ if (p.IndexOf("\\bin\\") > 0)
¡¡¡¡ {
¡¡¡¡ if (p.EndsWith("\\bin\\Debug\\"))
¡¡¡¡ p = p.Replace("\\bin\\Debug", "");
¡¡¡¡ if (p.EndsWith("\\bin\\Release\\"))
¡¡¡¡ p = p.Replace("\\bin\\Release", "");
¡¡¡¡ }
¡¡¡¡ if (!p.EndsWith("App_Data\\"))
¡¡¡¡ p = p + "db\\";
¡¡¡¡ p = p + "App_Data\\";//ÕâÀï¿ÉÒÔÖ¸¶¨ÏîÄ¿Êý¾Ý¿âÎļþ¼ÐÃû
¡¡¡¡ AppDomain.CurrentDomain.SetData("DataDirectory", p);
¡¡¡¡ Application.EnableVisualStyles();
¡¡¡¡ Application.SetCompatibleTextRenderingDefault(false);
¡¡¡¡Æäʵ×îºóbin\\debug\\dbÏ»¹ÊÇ»áÓÐÒ»·ÝÊý¾Ý¿âÎļþ£¬µ«ÊǽøÐеIJÙ×÷¿ÉÒÔÂäʵ·´Ó¦µ½ÍâÃæÏîÄ¿ÀïÊý¾Ý¿âÎļþÁË¡£App.configÎļþÀïµÄÁ¬½Ó×Ö·û´®Îª£ºconnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Êý¾Ý¿âÃû.mdb"
¡£
Ïà¹ØÎĵµ£º
C#ʹÓÃSQLiteÊý¾Ý¿â(asp.net/winform)
2009Äê1ÔÂ7ÈÕ
ÆÀÂÛ
·¢±íÆÀÂÛ
SQLite
ÊÇĿǰ±È½ÏÁ÷ÐеÄÒ»¸ö¿ªÔ´¡¢Ãâ·ÑµÄСÐ͵ÄEmbeddable RDBMS(¹ØÏµÐÍÊý¾Ý¿â)£¬ÓÃCʵÏÖ£¬ÄÚ´æÕ¼ÓýÏС£¬Ö§³Ö¾ø´óÊýµÄSQL92±ê×¼£¬¸ö±ð²»Ö§³ÖµÄÇé¿ö£¬ÔÚÕâÀï
˵Ã÷
¶Ô¸÷ÖÖÓïÑÔµÄÖ§³ÖÒ²±È½Ï²»´í£¬wrapperºÜ¶à¡ ......
http://ayic1.blog.163.com/blog/static/27343030200965103528805/
¾²Ì¬±äÁ¿
µ±ÎÒÃDZàдһ¸öÀàʱ£¬Æäʵ¾ÍÊÇÔÚÃèÊöÆä¶ÔÏóµÄÊôÐÔºÍÐÐΪ£¬¶ø²¢Ã»ÓвúÉúʵÖÊÉϵĶÔÏó£¬Ö»ÓÐͨ¹ýnew¹Ø¼ü×ֲŻá²úÉú³ö¶ÔÏó£¬Õâʱϵͳ²Å»á·ÖÅäÄÚ´æ¿Õ¼ä¸ø¶ÔÏ󣬯䷽·¨²Å¿ÉÒÔ¹©Íⲿµ÷Óá£
& ......
ÏÂÃæÊÇcommond:
MySQLCommand cmd;
cmd = new MySQLDriverCS.MySQLCommand("DROP TABLE IF EXISTS test.mysqldrivercs_test",conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
ÏÂÃæÊÇinsert:
string Value = "Value";
int SettingID = 1;
new MySQLInsertCommand(conn,
new object[,] {{"SettingID",SettingID},{"S ......
// BeginGroupCpp.cpp
// compile with: /EHsc
#import "msadox.dll" no_namespace
#include "iostream"
using namespace std;
inline void TESTHR(HRESULT x) {if FAILED(x) _com_issue_error(x);};
int main() {
if (FAILED(::CoInitialize(NULL)) )
return -1;
&n ......
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 ......