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);
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
vc中用odbc的方法访问access数据库，用到了cdatabase类和crecordset类。数据源在窗口初始化的时候被打开g_datasource.Open("data",FALSE,FALSE); 点击一个按钮启动一个定时器，在定时器内完成以下操作，定 ......
