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);
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......