62,267
社区成员
发帖
与我相关
我的任务
分享 <form id="form1" runat="server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:AUTOConnectionString5 %>"
DeleteCommand="DELETE FROM [BuildStatus] WHERE [id] = @id"
InsertCommand="INSERT INTO [BuildStatus] ([name], [StatusFrom], [StatusTo], [SubscribeStatus]) VALUES (@name, @StatusFrom, @StatusTo, @SubscribeStatus)"
SelectCommand="SELECT * FROM [BuildStatus]"
UpdateCommand="UPDATE [BuildStatus] SET [name] = @name, [StatusFrom] = @StatusFrom, [StatusTo] = @StatusTo, [SubscribeStatus] = @SubscribeStatus WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="StatusFrom" Type="String" />
<asp:Parameter Name="StatusTo" Type="String" />
<asp:Parameter Name="SubscribeStatus" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="StatusFrom" Type="String" />
<asp:Parameter Name="StatusTo" Type="String" />
<asp:Parameter Name="SubscribeStatus" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
ReadOnly="True" SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
<asp:BoundField DataField="StatusFrom" HeaderText="StatusFrom"
SortExpression="StatusFrom" />
<asp:BoundField DataField="StatusTo" HeaderText="StatusTo"
SortExpression="StatusTo" />
<asp:BoundField DataField="SubscribeStatus" HeaderText="SubscribeStatus"
SortExpression="SubscribeStatus" />
</Columns>
</asp:GridView>
</form>
<input name="Reset" type="reset" onClick="return clearbutton()" value="重写">
<script type="text/javascript">
function clearbutton()
{
if (!confirm("确定要重写吗?")) return false;
}
</script>