string sql = "update leadspeak set images=@images,content=@content,author=@author,title=@title where id=@id";
OleDbParameter[] para = new OleDbParameter[]{
new OleDbParameter("@id",leadSpeak.Id),
new OleDbParameter("@images",leadSpeak.Images),
new OleDbParameter("@content",leadSpeak.Content),
new OleDbParameter("@author",leadSpeak.Author),
new OleDbParameter("@title",leadSpeak.Title)
};
int num= DBHelper.ExecuteNonQuery(sql, CommandType.Text, para);
²»±¨´íÎ󣬵«¸üв»ÁË£¬·µ»ØµÄÊÇ0£¬Ð»Ð»£¡£¡
¸Ä³É£¿ÔÙÊÔÊÔ
C# code:
string sql = "update leadspeak set images=?,content=?,author=?,title=? where id=?";
OleDbParameter[] para = new OleDbParameter[]{
new OleDbParameter("?",leadSpeak.Id),
new OleDbParameter("?",leadSpeak.Images),
new OleDbParameter("?",leadSpeak.Content),
new OleDbParameter("?",leadSpeak.Author),
new OleDbParameter("?",leadSpeak.Title)
};
int num= DBHelper.ExecuteNonQuery(sql, CommandType.Text, para);
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×° ......
¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿
×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿
Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx
×î¶àÖ§³Ö¶àÉÙ²¢· ......