我有一个表ask,里面有三个字段pid,mid,subtime为符合主键,现在想通过sqldatasource的updatecommand来更新
所以给updatecommand赋值为
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Amgou %>"
DeleteCommand="delete from ask where pid=? and mid =? and subtime=?"
ProviderName="<%$ ConnectionStrings:Amgou.ProviderName %>"
SelectCommand="SELECT * FROM ask"
UpdateCommand="update ask set cname = ?,title = ?,question=?,answer=?,answertime=? WHERE pid=? AND mid=? AND subtime=?">
</asp:SqlDataSource>
由于数据库为mysql,所以占位符都用"?".请各位大虾帮个忙谢谢。
所以给updatecommand赋值为
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Amgou %>"
DeleteCommand="delete from ask where pid=? and mid =? and subtime=?"
ProviderName="<%$ ConnectionStrings:Amgou.ProviderName %>"
SelectCommand="SELECT * FROM ask"
UpdateCommand="update ask set cname = ?,title = ?,question=?,answer=?,answertime=? WHERE pid=? AND mid=? AND subtime=?">
</asp:SqlDataSource>
由于数据库为mysql,所以占位符都用"?".请各位大虾帮个忙谢谢。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货