ÔõÑù±£´æHTML´úÂëµ½ACCESSÊý¾Ý¿â£¿
ÒѾ½«Êý¾ÝÀàÐÍÉèÖÃΪ±¸×¢ÀàÐÍ
C# code:
FCKeditor1µÄÖµÈçÏ£º
string strcode="ertyrety<br />";
strcode+="tyit<br />";
strcode+="<input src="/B2C/UploadFiles/f2994d0cd90410525423500467de4a66.jpg" width="300" height="200" "; strcode+="type="image" /><br /> ";
sql = "insert into m_news(newsTitle,newsDesc,updteTime,updateUser) values ( @newsTitle,@newsDesc,@updteTime,@updateUser)";
OleDbParameter[] paras =
{
new OleDbParameter("@newsTitle", OleDbType.VarChar, 10),
new OleDbParameter("@newsDesc", OleDbType.VarWChar, 1000), //Ìî¶à´óºÏÊÊ£¿1000£¿
new OleDbParameter("@updteTime", OleDbType.Date, 8),
new OleDbParameter("@updateUser", OleDbType.VarChar, 20)
};
paras[0].Value = txtTitle.Text;
paras[1].Value = HttpUtility.HtmlEncode(FCKeditor1.Value);
paras[2].Value = System.DateTime.Now.ToShortDateString();
paras[3].Value = Session["username"] == null ? "" : Session["username"].ToString();
try
{
SqlHelper.ExecuteNonQuery(SqlHelper.Conn2, CommandType.Text, sql, paras);
}
±£´æµ½Êý¾
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿
Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
delphi 2007 + access 2007 +odbc +TADODataset,TADOConnection,TADOCommand
//ɾ³ýÊý¾Ý
procedure TCDSSelectTools.DeleteMachine(byMachineID: string);
tmpCmd := TADOCommand.Create(ni ......