accessÊÂÎñ²åÈë¶àÌõ¼Ç¼
protected void Button1_Click(object sender, EventArgs e)
{
/*=============²âÊÔͨ¹ý===============*/
OleDbConnection con = new
OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data
Source=C:/Inetpub/wwwroot/DotNetArticle/App_Data/DotNetArticle.mdb");
con.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.Transaction = con.BeginTransaction();
try
{
string sql1 = "insert into teaminfo (num,username,isplay) values(1,'a',1)";
string sql2 = "insert into teaminfo (num,username,isplay) values(2,'b',1)";
string sql3 = "insert into teaminfo (num,username,isplay) values(3,'c',1)";
string[] SQLStringList = { sql1, sql2, sql3 };
for (int n = 0; n < SQLStringList.Length; n++)
{
string strsql = SQLStringList[n].ToString();
if (strsql.Trim().Length > 1)
{
Ïà¹ØÎĵµ£º
ÏÖÏó£º
ESXµÄWEB·ÃÎÊĬÈÏÊǹرյģ¬ÍøÉϺܶàÎÄÕ¶¼ËµÊ¹ÓÃchkconfig vmware-webAccess onÀ´È÷þÎñ×Ô¶¯¿ªÆô£¬²»¹ýÕâÑù²Ù×÷Ö®ºóÖØÆô»úÆ÷£¬WEB·ÃÎÊ»¹ÊÇ»¹»á³ö503ÎÞ·¨·ÃÎÊ´íÎó£¬ESX²»ÖªµÀΪʲô»á×Ô¶¯°Ñvmware-webAccess ¸ø½ûÓõô¡£
½â¾ö·½·¨£º
¾¹ýÎÞÊý´Î³¢ÊÔÖ®ºó·¢ÏÖÁ˽â¾ö·½·¨£¬ÃüÁîÈçÏ£º
cd /etc/init.d
cp vmware-web ......
ÔÎÄ£ºhttp://www.cnblogs.com/whitetiger/archive/2007/03/27/689620.html
ÔÚBETA2ÖУ¬¡£NETÌṩÁËÒÔϵÄNAMESPACE£º
System.Data Namespace
System.Data.OleDb £¨ºÍBETA1ÖÐÒѾ²»Í¬ÁË£¬ËùÒÔÈç¹ûÄÃBETA1ÖеijÌÐòµ½BETA2ÖÐÀ´ÔËÐп϶¨²»¿ÉÒԵģ©
Èç¹ûÏë½²Çå³þÕâЩ¶«Î÷£¬ÎÒ²»ÈÏΪÊÇÎÒ¿ÉÒÔ×÷µ½µÄ£¬ËùÒÔÎÒÏëͨ¹ýһЩ¾ ......
×î½üÔÚ×öAccessµÄÒ»¸öÏîÄ¿£¬×ÜÊÇĪÃûÆäÃîµÄÌáʾ£º“Insert Into Óï·¨´íÎ󔣬ÕâÑùµÄÐÅÏ¢×ܸøÈË´øÀ´ºÜ¶àÂé·³£¬ÓÐʱºòΪÁËÕâÑùÒ»¸ö´íÎóÒªÕҺþòÅÄܽâ¾öÎÊÌ⣬"Insert Into Óï·¨´íÎó"Õâ¸öÌáʾ±¾Éí°üº¬µÄÐÅÏ¢Á¿ºÜÉÙ£¬ÔÚ¸ú×Ù¶ÑÕ»ÖÐÓÐÕÒ²»µ½¸üÏêϸµÄÐÅÏ¢£¬ÎªÁ˱ÜÃâ´ó¼ÒÔÚ¿ª·¢µÄ¹ý³ÌÖÐÓöµ½Í¬ÑùµÄ´íÎóºÍÀ§ÈÅ¡£Í¨¹ý²éÕÒºÍ ......
´ÓAccessÊý¾Ý¿âµ¼Èëµ½SQL
·½·¨Ò»:
ÔÚMSsqlÖÐÒª¼òÀúODBC..·½·¨±È½Ï±¿µã..
·½·¨¶þ:
Ö±½Ó´ÓAccessÉýǨµ½MSsql..
ÒòΪAccessÊý¾Ý¿âÓÐÉèÖÃÃÜÂë..»¹Õæ²»ºÃ¸ã..¸ãÁ˺ü¸´Î¶¼Ê§°ÜÁË..
ÀûÓ÷½·¨¶þ..Ò»´Î³É¹¦..
ÓÃÊý¾Ý¿âÉýǨ...¼òµ¥...
½¨ÒéʹÓõڶþÖÖ·½·¨µ¼ÈëACCESSÊý¾Ý¿âµ½MSSQLÊý¾Ý¿âÖÐ..Ê¡ÊÂ!!! ......