本文代碼的作用是如何使用SqlDataSource控制項新增記錄並同時返回改記錄的自增ID
資料庫指令碼:
create table tb([ID] int identity(1,1) ,[Name] varchar(10))
aspx :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><br /><html xmlns="http://www.w3.org/1999/xhtml"><br /><head runat="server"><br /> <title></title><br /></head><br /><body><br /> <form id="form1" runat="server"></p><p> 姓名:<asp:TextBox ID="txt" runat="server"></asp:TextBox> <br /> <asp:Button ID="btn" runat="server" Text="新增" OnClick="btn_Click" /></p><p> <asp:GridView ID="gv" runat="server"><br /> </asp:GridView></p><p> <asp:SqlDataSource ID="sd" runat="server"<br /> SelectCommand="select * from tb "<br /> InsertCommand="insert into tb (Name) values (@Name);select @ID=SCOPE_IDENTITY()"<br /> DataSourceMode="DataReader"<br /> ConnectionString="server=.;database=xxx;uid=xxx;pwd=xxx"<br /> OnInserted="sd_Inserted"><br /> <InsertParameters><br /> <asp:ControlParameter ControlID="txt" DbType="String" DefaultValue="Sandy" Name="Name"<br /> Direction="Input" /><br /> <asp:Parameter DbType="Int32" Name="ID" Direction="Output" /><br /> </InsertParameters><br /> </asp:SqlDataSource></p><p> </form><br /></body><br /></html><br />
aspx.cs
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
