<%@ Page Language="C#" AutoEventWireup="true" CodeFile="lisamisegahaldus.aspx.cs" Inherits="lisamisegahaldus" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [bensiinihinnad] WHERE [id] = @id" InsertCommand="INSERT INTO [bensiinihinnad] ([tyyp], [hind]) VALUES (@tyyp, @hind)" SelectCommand="SELECT [id], [tyyp], [hind] FROM [bensiinihinnad]" UpdateCommand="UPDATE [bensiinihinnad] SET [tyyp] = @tyyp, [hind] = @hind WHERE [id] = @id"> <DeleteParameters> <asp:Parameter Name="id" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="tyyp" Type="String" /> <asp:Parameter Name="hind" Type="Decimal" /> <asp:Parameter Name="id" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="tyyp" Type="String" /> <asp:Parameter Name="hind" Type="Decimal" /> </InsertParameters> </asp:SqlDataSource> <br /> <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 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="tyyp" HeaderText="tyyp" SortExpression="tyyp" /> <asp:BoundField DataField="hind" HeaderText="hind" SortExpression="hind" /> </Columns> </asp:GridView> <br /> <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="id" DataSourceID="SqlDataSource1" DefaultMode="Insert" Height="50px" Width="125px"> <Fields> <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" SortExpression="id" /> <asp:BoundField DataField="tyyp" HeaderText="tyyp" SortExpression="tyyp" /> <asp:BoundField DataField="hind" HeaderText="hind" SortExpression="hind" /> <asp:CommandField ShowInsertButton="True" /> </Fields> </asp:DetailsView> <br /> <br /> </div> </form> </body> </html>