62,046
社区成员
发帖
与我相关
我的任务
分享
<asp:FormView ID="FormView1" runat="server" DataKeyNames="id"
DataSourceID="SqlDataSource1">
<EditItemTemplate>
id:
<asp:Label ID="idLabel1" runat="server" Text='<%# Eval("id") %>' />
<br />
name:
<asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="更新" />
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="取消" />
</EditItemTemplate>
<InsertItemTemplate>
name:
<asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="插入" />
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="取消" />
</InsertItemTemplate>
<ItemTemplate>
id:
<asp:Label ID="idLabel" runat="server" Text='<%# Eval("id") %>' />
<br />
name:
<asp:Label ID="nameLabel" runat="server" Text='<%# Bind("name") %>' />
<br />
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False"
CommandName="New" Text="新建" />
</ItemTemplate>
</asp:FormView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:CLIMS_CRMConnectionString1 %>"
InsertCommand="INSERT INTO test(name) VALUES (@name);Select @NewID=Scope_Identity();"
SelectCommand="select * from test" oninserted="SqlDataSource1_Inserted">
<InsertParameters>
<asp:Parameter Name="name" />
<asp:Parameter Name="NewID"/>
</InsertParameters>
</asp:SqlDataSource>
protected void SqlDataSource1_Inserted(object sender, SqlDataSourceStatusEventArgs e)
{
for (int i = 0; i < e.Command.Parameters.Count; i++)
{
Response.Write(e.Command.Parameters[i].Value + "<br />");
}
}
Select @NewID=Scope_Identity();