You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
35 lines
2.6 KiB
35 lines
2.6 KiB
<%@ Page Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="True" CodeBehind="Athleten.aspx.cs" Inherits="QW2021C.Administration.Athleten" %>
|
|
|
|
<%@ Register Assembly="Syncfusion.EJ.Web, Version=18.3460.0.35, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" Namespace="Syncfusion.JavaScript.Web" TagPrefix="ej" %>
|
|
<%@ Register Assembly="Syncfusion.EJ, Version=18.3460.0.35, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89" Namespace="Syncfusion.JavaScript.Models" TagPrefix="ej" %>
|
|
|
|
<asp:Content ID="MainContent" ContentPlaceHolderID="MainContent" runat="Server">
|
|
<asp:Label runat="server"><h4>Athleten</h4></asp:Label>
|
|
<ej:Grid ID="Grid1" runat="server" CssClass="" DataSourceCachingMode="None" DataSourceID="SqlDataSource1" EnableLoadOnDemand="False" Locale="de-CH" MinWidth="0" AllowPaging="True" AllowSorting="True" AllowFiltering="True">
|
|
<Columns>
|
|
<ej:Column DataType="number" Field="id_athlete" AllowEditing="False" IsIdentity="True" IsPrimaryKey="True" HeaderText="ID" Width="60px" >
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="license" HeaderText="Lic." Width="90px">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="license_paid" HeaderText="Paid" width="50px">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="license_cat" HeaderText="Cat." Width="100px">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="lastname" HeaderText="Lastname">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="firstname" HeaderText="Firstname">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="sex" HeaderText="G." Width="30px" >
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="nationality" HeaderText="Nat." Width="50px">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="birth_date" HeaderText="Geb-Dat" Width="100px">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="account_name" HeaderText="Verein" Width="300px">
|
|
</ej:Column>
|
|
</Columns>
|
|
</ej:Grid>
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:QWToolConnectionString %>"
|
|
SelectCommand="SELECT base_athlete.id_athlete, base_athlete.license, base_athlete.license_paid, base_athlete.license_cat, base_athlete.lastname, base_athlete.firstname, base_athlete.sex, base_athlete.nationality, base_athlete.birth_date, base_account.account_name FROM base_athlete INNER JOIN base_account ON base_athlete.account_code = base_account.account_code"></asp:SqlDataSource>
|
|
|
|
</asp:Content> |