C# code:
StringBuilder strSql = new StringBuilder();
strSql.Append("update news set ");
strSql.Append("Title=@Title,");
strSql.Append("Come=@Come,");
strSql.Append("Content=@Content,");
strSql.Append("Times=@Times,");
strSql.Append("img=@img,");
strSql.Append("TOPID=@TOPID,");
strSql.Append("newsimg_type_id=@newsimg_type_id,");
strSql.Append("news_type_id=@news_type_id");
strSql.Append(" where ID=@ID ");
OleDbParameter[] parameters = {
new OleDbParameter("@ID", OleDbType.Integer,4),
new OleDbParameter("@Title", OleDbType.VarChar,100),
new OleDbParameter("@Come", OleDbType.VarChar,200),
new OleDbParameter("@Content", OleDbType.VarChar,0),
new OleDbParameter("@Times", OleDbType.Date),
new OleDbParameter("@img", OleDbType.VarChar,255),
new OleDbParameter("@TOPID", OleDbType.Integer,4),
new OleDbParameter("@newsimg_type_id", OleDbType.Integer,4),
n
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:
<?xml version="1.0" encoding="utf-8"? ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......