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.
39 lines
3.0 KiB
39 lines
3.0 KiB
<%@ Page MasterPageFile="~/Site.Master" Language="C#" AutoEventWireup="true" CodeBehind="Disziplin_Bezeichnung.aspx.cs" Inherits="QW2021C.Resultate.Disziplin_Bezeichnung" %>
|
|
|
|
|
|
<%@ 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" %>
|
|
<%@ Register assembly="Syncfusion.EJ" namespace="Syncfusion.JavaScript.Models" tagprefix="ej" %>
|
|
<asp:Content ID="MainContent" ContentPlaceHolderID="MainContent" runat="Server">
|
|
<asp:Label runat="server"><h4>Disziplin-Bezeichnung auf Auswertungen</h4></asp:Label>
|
|
<ej:Grid ID="Diszplingrid" runat="server" CssClass="" DataSourceCachingMode="None" DataSourceID="SqlDataSource1" EnableLoadOnDemand="False" Locale="de-DE" MinWidth="0">
|
|
<Columns>
|
|
<ej:Column AllowEditing="False" DataType="number" Field="DisziplinMappingNr" IsIdentity="True" IsPrimaryKey="True" Width="60px">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="Kategorie" Width="100px">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="QW" HeaderText="Original-Bezeichnung" Width="100px">
|
|
</ej:Column>
|
|
<ej:Column DataType="string" Field="Rangliste" HeaderText="Bezeichnung Rangliste">
|
|
</ej:Column>
|
|
</Columns>
|
|
<EditSettings AllowEditing="true" EditMode="Normal" AllowAdding="true" AllowDeleting="true"/>
|
|
<ToolbarSettings ShowToolbar="true" ToolbarItems="add,edit,delete,update,cancel"></ToolbarSettings>
|
|
</ej:Grid>
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:QWToolConnectionstring %>" DeleteCommand="DELETE FROM [Disziplin_Mapping] WHERE [DisziplinMappingNr] = @DisziplinMappingNr" InsertCommand="INSERT INTO [Disziplin_Mapping] ([Kategorie], [QW], [Rangliste]) VALUES (@Kategorie, @QW, @Rangliste)" SelectCommand="SELECT [DisziplinMappingNr], [Kategorie], [QW], [Rangliste] FROM [Disziplin_Mapping]" UpdateCommand="UPDATE [Disziplin_Mapping] SET [Kategorie] = @Kategorie, [QW] = @QW, [Rangliste] = @Rangliste WHERE [DisziplinMappingNr] = @DisziplinMappingNr">
|
|
<DeleteParameters>
|
|
<asp:Parameter Name="DisziplinMappingNr" Type="Int32" />
|
|
</DeleteParameters>
|
|
<InsertParameters>
|
|
<asp:Parameter Name="Kategorie" Type="String" />
|
|
<asp:Parameter Name="QW" Type="String" />
|
|
<asp:Parameter Name="Rangliste" Type="String" />
|
|
</InsertParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="Kategorie" Type="String" />
|
|
<asp:Parameter Name="QW" Type="String" />
|
|
<asp:Parameter Name="Rangliste" Type="String" />
|
|
<asp:Parameter Name="DisziplinMappingNr" Type="Int32" />
|
|
</UpdateParameters>
|
|
</asp:SqlDataSource>
|
|
</asp:Content> |