110,544
社区成员
发帖
与我相关
我的任务
分享
<asp:SqlDataSource ID="ResSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:connStrPTQRY_HXS %>"
ProviderName="<%$ ConnectionStrings:connStrPTQRY_HXS.ProviderName %>"
UpdateCommand="update myTable set seq_id=@seq_id, modify_id=@modify_id, modify_time=sysdate, modify_content=@modify_content, status=0 where status <> 1 and seq_id=@original_seq_id and id=@id" >
<UpdateParameters>
<asp:Parameter Type="Decimal" Name="seq_id" />
<asp:Parameter Type="Decimal" Name="modify_id" />
<asp:Parameter Type="String" Name="modify_content" />
<asp:Parameter Type="Decimal" Name="original_seq_id" />
<asp:Parameter Type="Decimal" Name="id" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:...... %>" SelectCommand="SELECT 表.* FROM 表"
UpdateCommand="UPDATE 表 SET 字段1 = @字段1, 字段2 = @字段2, WHERE (id = @id)">
<UpdateParameters>
<asp:Parameter Name="字段1" />
<asp:Parameter Name="字段2" />
</UpdateParameters>
</asp:SqlDataSource>
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (e.NewValues[0] != null & e.OldValues[0] != null)
{
if (e.NewValues[0].ToString() == e.OldValues[0].ToString())//0是指第一个位置编辑
e.Cancel = true;
}
}