<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="koeranimi" HeaderText="koeranimi"
SortExpression="koeranimi" />
<asp:BoundField DataField="synniaasta" HeaderText="synniaasta"
SortExpression="synniaasta" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
DeleteCommand="DELETE FROM [koertetabel] WHERE [id] = @id"
InsertCommand="INSERT INTO [koertetabel] ([koeranimi], [synniaasta]) VALUES (@koeranimi, @synniaasta)"
SelectCommand="SELECT [id], [koeranimi], [synniaasta] FROM [koertetabel] WHERE ([koeranimi] LIKE '%' + @koeranimi + '%') ORDER BY [koeranimi]"
UpdateCommand="UPDATE [koertetabel] SET [koeranimi] = @koeranimi, [synniaasta] = @synniaasta WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="koeranimi" Type="String" />
<asp:Parameter Name="synniaasta" Type="Int32" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="koeranimi" PropertyName="Text"
Type="String" ConvertEmptyStringToNull="false" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="koeranimi" Type="String" />
<asp:Parameter Name="synniaasta" Type="Int32" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</form>
</body>
</html>