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)
{
Ïà¹ØÎĵµ£º
Ëùν“´æÈ¡¼ü”¾ÍÏñ windows Ó¦ÓóÌÐòÖÐµÄ Alt ¿ì½Ý¼ü£¬Í¬Ê±°´ Alt ¼üºÍij¸ö×Öĸ¼ü£¬¿ÉÒÔ¿ìËÙÇл»µ½Îı¾¿ò¡¢°´Å¥µÈÒ³Ãæ¶ÔÏóÉÏ¡£
(1)¡¢Îı¾¿òµÄ Access Key£º
<FORM>
<LABEL FOR="Namebox" ACCESSKEY="N"><U>N</U>ame:</LABEL>
<INPUT TYPE="TEXT" ID="Namebox" SIZE=30> ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Common;
us ......
ÏÖÏó£º
ESXµÄWEB·ÃÎÊĬÈÏÊǹرյģ¬ÍøÉϺܶàÎÄÕ¶¼ËµÊ¹ÓÃchkconfig vmware-webAccess onÀ´È÷þÎñ×Ô¶¯¿ªÆô£¬²»¹ýÕâÑù²Ù×÷Ö®ºóÖØÆô»úÆ÷£¬WEB·ÃÎÊ»¹ÊÇ»¹»á³ö503ÎÞ·¨·ÃÎÊ´íÎó£¬ESX²»ÖªµÀΪʲô»á×Ô¶¯°Ñvmware-webAccess ¸ø½ûÓõô¡£
½â¾ö·½·¨£º
¾¹ýÎÞÊý´Î³¢ÊÔÖ®ºó·¢ÏÖÁ˽â¾ö·½·¨£¬ÃüÁîÈçÏ£º
cd /etc/init.d
cp vmware-web ......
×ò
ÌìºÍanimatorÊÔÑéÁËһϣ¬°Ñdata.mdbÎļþ¸ÄÃûΪdata.aspÎļþºó·ÅÔÚwwwrootĿ¼ÀȻºóÔÚIEÖÐÊäÈëdata.asp·¾¶
ºó£¬·¢ÏÖIEÏÔʾһƬ¿Õ°×£¬ÓÒ¼ü->²ì¿´Ô´Îļþ£¬Ìø³ö¼Çʱ¾£¬½«ÄÚÈÝÁí´æÎª.mdbÎļþ£¬ÓÃACCESS´ò¿ª£¬·¢ÏÖÐèÒªÃÜÂ룬Ҳ¾ÍÊÇ˵ÖÁÉÙÎļþÍ·±»
ÆÆ»µ¡£
È»ºóÓÃFlashgetÊÔÑéÏÂÔØdata.aspÎļþ£¬²¢Áí´æÎªda ......
ÔÚACCESS(2007)Êý¾Ý¿âÖУ¬ÓÐÕâÑùÒ»¸öÄ£ºý²éѯ£¬
select postId,postName,postType,left(postTime,10) as postTimes from PostInfo where postUser like '*ÖÜ·¼*'
ÔÚÊý¾Ý¿â²éѯºó½á¹ûÏÔʾÕýÈ·£¬¿ÉÊÇ·ÅÔÚÏîÄ¿µÄ´úÂëÖУ¬¾ÓÈ»²»ÏÔʾ²éѯµÄ½á¹û¿©¡£¼ì²éÁ˰ëÌ춼ûÓз¢ÏÖ´íÎóÔÚÄÄÀ×îºó²ÅÖªµÀ£¬ÓеÄACCESS¾ÓÈ»²»ÈÏʶͨŠ......