1
<asp:Parameter Name="newid" Direction="Output" Size="5" Type="int32" />
</InsertParameters>
2
InsertCommand="INSERT INTO [Companies] ([CompanyName],])
VALUES (@CompanyName,@deleted);select @newid=@@identity"
3
protected void getthenewid(object sender, SqlDataSourceStatusEventArgs e) {
Label1.Text = Convert.ToString(e.Command.Parameters["@newid"].Value);
}
4
<asp:SqlDataSource ID="SqlDataSource1" runat="server" OnInserted="getthenewid"