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
Ïà¹ØÎÊ´ð£º
1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ã棬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£
js ......
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøվͼƬ¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔضԻ°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")
ÒýÓÃ
Response.Redirect( ......