- <%@ Page Language="C#" Title="Untitled Page" %>
-
- <script runat="server">
-
- protected void AddButton_Click(object sender, EventArgs e)
- {
- SqlDataSource1.Insert();
- GridView1.DataBind();
- GridView1.PageIndex=GridView1.PageCount;
- GridView1.EditIndex = GridView1.Rows.Count - 1;
-
- }
- </script>
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head><title>Manage currency</title></head>
- <body>
- <div>
- <h3>Manage currencies</h3>
- <form action="Default.aspx" runat="server">
- <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
- DataKeyNames="id" AllowPaging="True" AutoGenerateColumns="False" AllowSorting="True" >
- <Columns>
-
- <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
- SortExpression="id" />
- <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
- <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
- </Columns>
-
- </asp:GridView>
- <asp:SqlDataSource ID="SqlDataSource1" runat="server"
- SelectCommand="Select * from [currency] order by id"
- InsertCommand="Insert into [currency] ([name]) values(@name)"
- UpdateCommand="Update [currency] set [name]=@name where [id]=@id"
- DeleteCommand="Delete from [currency] where [id]=@id; DBCC CheckIdent(currency,reseed,0); DBCC CheckIdent(currency,reseed)"
- ConnectionString="<%$ ConnectionStrings:connexion %>"
- >
- <InsertParameters>
- <asp:Parameter Type="String" Name="name" DefaultValue="(new)" />
- </InsertParameters>
- </asp:SqlDataSource>
- <asp:LinkButton ID="AddButton" Text="Add new currency" runat="server" OnClick="AddButton_Click"/>
-
- </form></div>
- </body>
- </html>
<%@ Page Language="C#" Title="Untitled Page" %>
<script runat="server">
protected void AddButton_Click(object sender, EventArgs e)
{
SqlDataSource1.Insert();
GridView1.DataBind();
GridView1.PageIndex=GridView1.PageCount;
GridView1.EditIndex = GridView1.Rows.Count - 1;
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>Manage currency</title></head>
<body>
<div>
<h3>Manage currencies</h3>
<form action="Default.aspx" runat="server">
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
DataKeyNames="id" AllowPaging="True" AutoGenerateColumns="False" AllowSorting="True" >
<Columns>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
SelectCommand="Select * from [currency] order by id"
InsertCommand="Insert into [currency] ([name]) values(@name)"
UpdateCommand="Update [currency] set [name]=@name where [id]=@id"
DeleteCommand="Delete from [currency] where [id]=@id; DBCC CheckIdent(currency,reseed,0); DBCC CheckIdent(currency,reseed)"
ConnectionString="<%$ ConnectionStrings:connexion %>"
>
<InsertParameters>
<asp:Parameter Type="String" Name="name" DefaultValue="(new)" />
</InsertParameters>
</asp:SqlDataSource>
<asp:LinkButton ID="AddButton" Text="Add new currency" runat="server" OnClick="AddButton_Click"/>
</form></div>
</body>
</html>