Asp.netÊý¾Ý²åÈëAccess - .NET¼¼Êõ / ASP.NET
ÏëAccess²åÈëÊý¾Ý£¨ÅúÁ¿£©£¬ÔÚVSÖ±½ÓÔËÐÐÊý¾Ý³É¹¦²åÈ룬µ«Èô·¢²¼ºóÔ¶³Ì²Ù×÷£¨Í¨¹ýIP£©,ÔòÊý¾ÝûÓвåÈë¡£ÎÒ½«Í¨¹ýIP²Ù×÷µÄAccess·¾¶ÏÔʾ³öÀ´£¬È·ÈÏ·þÎñÆ÷·¾¶ÊǶԵģ¬¿É¾ÍÊDz»³É¹¦£¬ÄÄλ֪µÀ¸øÖ¸µãһϡ£
C# code:
public static bool UpdataDb(DataTable dt, string tableName)
{
bool flag = false;
Cdatabase AccessDb = new Cdatabase();
try
{
string sqlText = "delete from " + tableName;
if (AccessDb.RunSQLcmd(sqlText))
{
string sqlcmd = "Insert Into " + tableName
+ " (Id, Name, userName, EdtDateTime,PathServer) values (@pId, @pName, @pUserName, @pEdtDt, @pPahtServer)";
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand(sqlcmd, (OleDbConnection)AccessDb.GetConn());
MyAdapter.InsertCommand = cmd;
cmd.Parameters.Add("@pId", OleDbType.VarChar, 10);
cmd.Parameters.Add("@pName", OleDbType.VarChar, 20);
cmd.Parameters.Add("@pUserName", OleDbType.VarChar);
cmd.Parameters.Add("@pEdtDt", OleDbType.Date, 10);
cmd.Parameters.Add(&qu
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
Microsoft JET Database Engine '80040e07'
±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£
\wwwroot\update.asp, line 20
--------------------------------------------------------------------------------
Ho ......
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......