<%@ 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>Veebikursuse teated</title>
<style type="text/css">
@import "kujundus.css";
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1>Teated veebikursusel</h1>
<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="aeg" HeaderText="aeg" SortExpression="aeg" />
<asp:BoundField DataField="pealkiri" HeaderText="pealkiri"
SortExpression="pealkiri" />
<asp:BoundField DataField="jutt" HeaderText="jutt" SortExpression="jutt" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:kursusebaasConnectionString1 %>"
DeleteCommand="DELETE FROM [teated] WHERE [id] = @id"
InsertCommand="INSERT INTO [teated] ([aeg], [pealkiri], [jutt]) VALUES (@aeg, @pealkiri, @jutt)"
ProviderName="<%$ ConnectionStrings:kursusebaasConnectionString1.ProviderName %>"
SelectCommand="SELECT [id], [aeg], [pealkiri], [jutt] FROM [teated]"
UpdateCommand="UPDATE [teated] SET [aeg] = @aeg, [pealkiri] = @pealkiri, [jutt] = @jutt WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="aeg" Type="DateTime" />
<asp:Parameter Name="pealkiri" Type="String" />
<asp:Parameter Name="jutt" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="aeg" Type="DateTime" />
<asp:Parameter Name="pealkiri" Type="String" />
<asp:Parameter Name="jutt" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<a href="Default.aspx">Avalehele</a>
</div>
</form>
</body>
</html>