<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"
Inherits="_Default" Culture="auto" UICulture="auto" %>
<!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>Jaagupi ajaveeb</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1>Ilusat lugemist kõigile, kes siia lehele juhtunud!</h1>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="id"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="pealkiri" HeaderText="Teate pealkiri"
SortExpression="pealkiri" />
<asp:BoundField DataField="sisu" HeaderText="Teate sisu" SortExpression="id" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:yhendus1 %>"
SelectCommand="SELECT [id], [pealkiri], [sisu] FROM [teated]">
</asp:SqlDataSource>
<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl="haldus/haldusleht.aspx" >Halduslehele</asp:HyperLink>
</div>
</form>
</body>
</html>