Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ Page Title="Mitgliederverwaltung des BTSC - Verwalten" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Mitglieder verwalten.aspx.cs" Inherits="Mitglieder_bearbeiten" %>
- <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
- <style type="text/css">
- .style1
- {
- width: 100%;
- }
- .obenlinks
- {
- text-align:left;
- vertical-align:top;
- }
- .style2
- {
- text-align: left;
- vertical-align: top;
- width: 310px;
- }
- .style5
- {
- width: 315px;
- }
- .style6
- {
- text-decoration: underline;
- font-size: large;
- }
- </style>
- </asp:Content>
- <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
- <table class="style1">
- <tr>
- <td class="style2">
- <span class="style6"><strong>Mitglieder</strong></span><br />
- <br />
- Nun können Sie ein bestimmtes Mitglied aus unserer Datenbank auswählen und
- bearbeiten. Dazu stehen diverse Funktionen zur Verfügung. Außerdem können Sie
- hier einem Mitglied einen bestimmten Status im Verein zuordnen:<br />
- <br />
- <br />
- <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
- DataSourceID="AccessDataSource1" DataTextField="m_tName"
- DataValueField="m_aNr" Height="23px" Width="222px"
- AppendDataBoundItems="True"
- onselectedindexchanged="DropDownList1_SelectedIndexChanged">
- <asp:ListItem Value="0">(Bitte wählen)</asp:ListItem>
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource1" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- SelectCommand="SELECT [m_tName], [m_aNr] FROM [Mitglied] ORDER BY [m_tName]">
- </asp:AccessDataSource>
- <asp:Button ID="zurueck" runat="server" onclick="zurueck_Click" Text="<" />
- <asp:Button ID="vorwaerts" runat="server" onclick="vorwaerts_Click"
- Text=">" />
- <br />
- </td>
- <td class="style5" colspan="2">
- <asp:DetailsView ID="DetailsView5" runat="server" AutoGenerateRows="False"
- DataKeyNames="m_aNr" DataSourceID="AccessDataSource2" Height="50px"
- Width="548px" CellPadding="3" GridLines="Vertical"
- onitemdeleted="DetailsView5_ItemDeleted"
- oniteminserted="DetailsView5_ItemInserted" BackColor="White"
- BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
- style="text-align: left" ondatabound="DetailsView5_DataBound"
- onitemupdated="DetailsView5_ItemUpdated">
- <AlternatingRowStyle BackColor="#DCDCDC" />
- <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
- <Fields>
- <asp:BoundField DataField="m_aNr" HeaderText="m-Nr" InsertVisible="False"
- ReadOnly="True" SortExpression="m_aNr" />
- <asp:TemplateField HeaderText="Vorname" SortExpression="m_tVorname">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("m_tVorname") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server"
- ControlToValidate="TextBox5" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("m_tVorname") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server"
- ControlToValidate="TextBox5" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label5" runat="server" Text='<%# Bind("m_tVorname") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Name" SortExpression="m_tName">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" ontextchanged="TextBox1_TextChanged"
- Text='<%# Bind("m_tName") %>' MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server"
- ControlToValidate="TextBox1" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("m_tName") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server"
- ControlToValidate="TextBox1" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("m_tName") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Geburt" SortExpression="m_zGeburt">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server"
- Text='<%# Bind("m_zGeburt", "{0:d}") %>'></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator32" runat="server"
- ControlToValidate="TextBox2" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:CompareValidator ID="CompareValidator6" runat="server"
- ControlToValidate="TextBox2" Display="Dynamic" ErrorMessage="Falsches Format"
- Operator="DataTypeCheck" Type="Date"></asp:CompareValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server"
- Text='<%# Bind("m_zGeburt", "{0:d}") %>'></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator33" runat="server"
- ControlToValidate="TextBox2" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:CompareValidator ID="CompareValidator7" runat="server"
- ControlToValidate="TextBox2" Display="Dynamic" ErrorMessage="Falsches Format"
- Operator="DataTypeCheck" Type="Date"></asp:CompareValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label2" runat="server" Text='<%# Bind("m_zGeburt", "{0:d}") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Geschlecht" SortExpression="m_tGeschlecht">
- <EditItemTemplate>
- <asp:DropDownList ID="DropDownList11" runat="server"
- AppendDataBoundItems="True" Height="21px"
- SelectedValue='<%# Bind("m_tGeschlecht") %>' Width="125px">
- <asp:ListItem Value="m">männlich</asp:ListItem>
- <asp:ListItem Value="w">weiblich</asp:ListItem>
- </asp:DropDownList>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList12" runat="server"
- AppendDataBoundItems="True" Height="16px"
- SelectedValue='<%# Bind("m_zGeburt") %>' Width="125px">
- <asp:ListItem Value="m">männlich</asp:ListItem>
- <asp:ListItem Value="w">weiblich</asp:ListItem>
- </asp:DropDownList>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label3" runat="server" Text='<%# Bind("m_tGeschlecht") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Strasse" SortExpression="m_tStrasse">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("m_tStrasse") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator11" runat="server"
- ControlToValidate="TextBox6" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("m_tStrasse") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator12" runat="server"
- ControlToValidate="TextBox6" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label6" runat="server" Text='<%# Bind("m_tStrasse") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="HausNr" SortExpression="m_tHausNr">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("m_tHausNr") %>'
- MaxLength="4"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator13" runat="server"
- ControlToValidate="TextBox7" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("m_tHausNr") %>'
- MaxLength="4"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator14" runat="server"
- ControlToValidate="TextBox7" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label7" runat="server" Text='<%# Bind("m_tHausNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="PLZ" SortExpression="m_tPLZ">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox8" runat="server" Text='<%# Bind("m_tPLZ") %>'
- MaxLength="5"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator15" runat="server"
- ControlToValidate="TextBox8" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"
- ControlToValidate="TextBox8" Display="Dynamic"
- ErrorMessage="PLZ nicht vorhanden" ValidationExpression="(D-)?\d{5}"></asp:RegularExpressionValidator>
- <br />
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox8" runat="server" Text='<%# Bind("m_tPLZ") %>'
- MaxLength="5"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator16" runat="server"
- ControlToValidate="TextBox8" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server"
- ControlToValidate="TextBox8" Display="Dynamic"
- ErrorMessage="PLZ nicht vorhanden" ValidationExpression="(D-)?\d{5}"></asp:RegularExpressionValidator>
- <br />
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label8" runat="server" Text='<%# Bind("m_tPLZ") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Ort" SortExpression="m_tOrt">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("m_tOrt") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator17" runat="server"
- ControlToValidate="TextBox9" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox9" runat="server" Text='<%# Bind("m_tOrt") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator18" runat="server"
- ControlToValidate="TextBox9" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label9" runat="server" Text='<%# Bind("m_tOrt") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Telefon" SortExpression="m_tTelefon">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("m_tTelefon") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server"
- ControlToValidate="TextBox4" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("m_tTelefon") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server"
- ControlToValidate="TextBox4" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label4" runat="server" Text='<%# Bind("m_tTelefon") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Email" SortExpression="m_tEmail">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("m_tEmail") %>'></asp:TextBox>
- <br />
- <asp:RegularExpressionValidator ID="RegularExpressionValidator3" runat="server"
- ControlToValidate="TextBox3" Display="Dynamic"
- ErrorMessage="Format nicht möglich"
- ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("m_tEmail") %>'></asp:TextBox>
- <br />
- <asp:RegularExpressionValidator ID="RegularExpressionValidator4" runat="server"
- ControlToValidate="TextBox3" Display="Dynamic"
- ErrorMessage="Format nicht möglich"></asp:RegularExpressionValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label13" runat="server" Text='<%# Bind("m_tEmail") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Beruf" SortExpression="m_tBeruf"><EditItemTemplate>
- <asp:TextBox ID="TextBox10" runat="server"
- Text='<%# Bind("m_tBeruf") %>' MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator19" runat="server"
- ControlToValidate="TextBox10" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox10" runat="server" Text='<%# Bind("m_tBeruf") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator20" runat="server"
- ControlToValidate="TextBox10" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label10" runat="server" Text='<%# Bind("m_tBeruf") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Lastschrift" SortExpression="m_tLastschrift">
- <EditItemTemplate>
- <asp:DropDownList ID="DropDownList18" runat="server"
- AppendDataBoundItems="True" Height="18px"
- SelectedValue='<%# Bind("m_tLastschrift") %>' Width="128px">
- <asp:ListItem>Jährlich</asp:ListItem>
- <asp:ListItem>Quartal</asp:ListItem>
- </asp:DropDownList>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList19" runat="server"
- AppendDataBoundItems="True" Height="18px"
- SelectedValue='<%# Bind("m_tLastschrift") %>' Width="128px">
- <asp:ListItem>Jährlich</asp:ListItem>
- <asp:ListItem>Quartal</asp:ListItem>
- </asp:DropDownList>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label11" runat="server" Text='<%# Bind("m_tLastschrift") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Beitrag" SortExpression="m_zBeitrag">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox12" runat="server"
- Text='<%# Bind("m_zBeitrag", "{0:N}") %>'></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator23" runat="server"
- ControlToValidate="TextBox12" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:CompareValidator ID="CompareValidator8" runat="server"
- ControlToValidate="TextBox12" Display="Dynamic" ErrorMessage="Falsches Format"
- Operator="DataTypeCheck" Type="Currency"></asp:CompareValidator>
- <br />
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox12" runat="server"
- Text='<%# Bind("m_zBeitrag", "{0:N}") %>'></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator24" runat="server"
- ControlToValidate="TextBox12" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:CompareValidator ID="CompareValidator5" runat="server"
- ControlToValidate="TextBox12" Display="Dynamic" ErrorMessage="Falsches Format"
- Operator="DataTypeCheck" Type="Currency"></asp:CompareValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label12" runat="server"
- Text='<%# Bind("m_zBeitrag", "{0:N}") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Bemerkung" SortExpression="m_mBemerkung">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox11" runat="server" MaxLength="50"
- Text='<%# Bind("m_mBemerkung") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox11" runat="server" MaxLength="50"
- Text='<%# Bind("m_mBemerkung") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label14" runat="server" Text='<%# Bind("m_mBemerkung") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
- ShowInsertButton="True" ButtonType="Image"
- CancelImageUrl="~/Zentral/Cancel.png" DeleteImageUrl="~/Zentral/Delete.png"
- EditImageUrl="~/Zentral/Edit.png" InsertImageUrl="~/Zentral/Insert.png"
- NewImageUrl="~/Zentral/New.png" SelectImageUrl="~/Zentral/Select.png"
- UpdateImageUrl="~/Zentral/Update.png" />
- </Fields>
- <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
- <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
- <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
- </asp:DetailsView>
- <asp:AccessDataSource ID="AccessDataSource2" runat="server"
- ConflictDetection="CompareAllValues"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- DeleteCommand="DELETE FROM [Mitglied] WHERE [m_aNr] = ?"
- InsertCommand="INSERT INTO [Mitglied] ([m_tVorname], [m_tName], [m_zGeburt], [m_tStrasse], [m_tHausNr], [m_tPLZ], [m_tOrt], [m_tEmail], [m_tGeschlecht], [m_mBemerkung], [m_tLastschrift], [m_zBeitrag], [m_tBeruf], [m_tTelefon]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
- OldValuesParameterFormatString="original_{0}"
- SelectCommand="SELECT [m_aNr], [m_tVorname], [m_tName], [m_zGeburt], [m_tStrasse], [m_tHausNr], [m_tPLZ], [m_tOrt], [m_tEmail], [m_tGeschlecht], [m_mBemerkung], [m_tLastschrift], [m_zBeitrag], [m_tBeruf], [m_tTelefon] FROM [Mitglied] WHERE ([m_aNr] = ?) ORDER BY [m_aNr]"
- UpdateCommand="UPDATE [Mitglied] SET [m_tVorname] = ?, [m_tName] = ?, [m_zGeburt] = ?, [m_tStrasse] = ?, [m_tHausNr] = ?, [m_tPLZ] = ?, [m_tOrt] = ?, [m_tEmail] = ?, [m_tGeschlecht] = ?, [m_mBemerkung] = ?, [m_tLastschrift] = ?, [m_zBeitrag] = ?, [m_tBeruf] = ?, [m_tTelefon] = ? WHERE [m_aNr] = ? AND [m_tVorname] = ? AND [m_tName] = ? AND [m_zGeburt] = ? AND [m_tStrasse] = ? AND [m_tHausNr] = ? AND [m_tPLZ] = ? AND [m_tOrt] = ? AND (([m_tEmail] = ?) OR ([m_tEmail] IS NULL AND ? IS NULL)) AND [m_tGeschlecht] = ? AND (([m_mBemerkung] = ?) OR ([m_mBemerkung] IS NULL AND ? IS NULL)) AND [m_tLastschrift] = ? AND (([m_zBeitrag] = ?) OR ([m_zBeitrag] IS NULL AND ? IS NULL)) AND [m_tBeruf] = ? AND [m_tTelefon] = ?">
- <DeleteParameters>
- <asp:Parameter Name="original_m_aNr" Type="Int32" />
- <asp:Parameter Name="original_m_tVorname" Type="String" />
- <asp:Parameter Name="original_m_tName" Type="String" />
- <asp:Parameter Name="original_m_zGeburt" Type="DateTime" />
- <asp:Parameter Name="original_m_tStrasse" Type="String" />
- <asp:Parameter Name="original_m_tHausNr" Type="String" />
- <asp:Parameter Name="original_m_tPLZ" Type="String" />
- <asp:Parameter Name="original_m_tOrt" Type="String" />
- <asp:Parameter Name="original_m_tEmail" Type="String" />
- <asp:Parameter Name="original_m_tEmail" Type="String" />
- <asp:Parameter Name="original_m_tGeschlecht" Type="String" />
- <asp:Parameter Name="original_m_mBemerkung" Type="String" />
- <asp:Parameter Name="original_m_mBemerkung" Type="String" />
- <asp:Parameter Name="original_m_tLastschrift" Type="String" />
- <asp:Parameter Name="original_m_zBeitrag" Type="Decimal" />
- <asp:Parameter Name="original_m_zBeitrag" Type="Decimal" />
- <asp:Parameter Name="original_m_tBeruf" Type="String" />
- <asp:Parameter Name="original_m_tTelefon" Type="String" />
- </DeleteParameters>
- <InsertParameters>
- <asp:Parameter Name="m_tVorname" Type="String" />
- <asp:Parameter Name="m_tName" Type="String" />
- <asp:Parameter Name="m_zGeburt" Type="DateTime" />
- <asp:Parameter Name="m_tStrasse" Type="String" />
- <asp:Parameter Name="m_tHausNr" Type="String" />
- <asp:Parameter Name="m_tPLZ" Type="String" />
- <asp:Parameter Name="m_tOrt" Type="String" />
- <asp:Parameter Name="m_tEmail" Type="String" />
- <asp:Parameter Name="m_tGeschlecht" Type="String" />
- <asp:Parameter Name="m_mBemerkung" Type="String" />
- <asp:Parameter Name="m_tLastschrift" Type="String" />
- <asp:Parameter Name="m_zBeitrag" Type="Decimal" />
- <asp:Parameter Name="m_tBeruf" Type="String" />
- <asp:Parameter Name="m_tTelefon" Type="String" />
- </InsertParameters>
- <SelectParameters>
- <asp:ControlParameter ControlID="DropDownList1" Name="m_aNr"
- PropertyName="SelectedValue" Type="Int32" />
- </SelectParameters>
- <UpdateParameters>
- <asp:Parameter Name="m_tVorname" Type="String" />
- <asp:Parameter Name="m_tName" Type="String" />
- <asp:Parameter Name="m_zGeburt" Type="DateTime" />
- <asp:Parameter Name="m_tStrasse" Type="String" />
- <asp:Parameter Name="m_tHausNr" Type="String" />
- <asp:Parameter Name="m_tPLZ" Type="String" />
- <asp:Parameter Name="m_tOrt" Type="String" />
- <asp:Parameter Name="m_tEmail" Type="String" />
- <asp:Parameter Name="m_tGeschlecht" Type="String" />
- <asp:Parameter Name="m_mBemerkung" Type="String" />
- <asp:Parameter Name="m_tLastschrift" Type="String" />
- <asp:Parameter Name="m_zBeitrag" Type="Decimal" />
- <asp:Parameter Name="m_tBeruf" Type="String" />
- <asp:Parameter Name="m_tTelefon" Type="String" />
- <asp:Parameter Name="original_m_aNr" Type="Int32" />
- <asp:Parameter Name="original_m_tVorname" Type="String" />
- <asp:Parameter Name="original_m_tName" Type="String" />
- <asp:Parameter Name="original_m_zGeburt" Type="DateTime" />
- <asp:Parameter Name="original_m_tStrasse" Type="String" />
- <asp:Parameter Name="original_m_tHausNr" Type="String" />
- <asp:Parameter Name="original_m_tPLZ" Type="String" />
- <asp:Parameter Name="original_m_tOrt" Type="String" />
- <asp:Parameter Name="original_m_tEmail" Type="String" />
- <asp:Parameter Name="original_m_tEmail" Type="String" />
- <asp:Parameter Name="original_m_tGeschlecht" Type="String" />
- <asp:Parameter Name="original_m_mBemerkung" Type="String" />
- <asp:Parameter Name="original_m_mBemerkung" Type="String" />
- <asp:Parameter Name="original_m_tLastschrift" Type="String" />
- <asp:Parameter Name="original_m_zBeitrag" Type="Decimal" />
- <asp:Parameter Name="original_m_zBeitrag" Type="Decimal" />
- <asp:Parameter Name="original_m_tBeruf" Type="String" />
- <asp:Parameter Name="original_m_tTelefon" Type="String" />
- </UpdateParameters>
- </asp:AccessDataSource>
- </td>
- </tr>
- </table>
- <panel>
- <br />
- </panel>
- <table>
- <tr>
- <td width="300" align="center" valign="top">
- <asp:CheckBox ID="CheckBox1" runat="server" Text="Ist Sportler"
- TextAlign="Left"
- style="font-size: medium; font-weight: 700; text-decoration: underline; text-align: center;"
- AutoPostBack="True" oncheckedchanged="CheckBox1_CheckedChanged" />
- <br />
- <br />
- <asp:DetailsView ID="DetailsView9" runat="server" AutoGenerateRows="False"
- DataKeyNames="m_aNr" DataSourceID="AccessDataSource3" Height="50px"
- Width="250px" BackColor="White" BorderColor="#999999" BorderStyle="None"
- BorderWidth="1px" CellPadding="3" GridLines="Vertical"
- ondatabound="DetailsView9_DataBound">
- <AlternatingRowStyle BackColor="#DCDCDC" />
- <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
- <Fields>
- <asp:TemplateField HeaderText="m-Nr" SortExpression="m_aNr">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("m_aNr") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("m_aNr") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label3" runat="server" Text='<%# Bind("m_aNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Förderung" SortExpression="s_tFörderung">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server"
- Text='<%# Bind("s_tFörderung", "{0:N}") %>'></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator29" runat="server"
- ControlToValidate="TextBox1" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:CompareValidator ID="CompareValidator9" runat="server"
- ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="Falsches Format"
- Operator="DataTypeCheck" Type="Currency"></asp:CompareValidator>
- <br />
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("s_tFörderung") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server"
- Text='<%# Bind("s_tFörderung", "{0:N}") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Status" SortExpression="s_tStatus">
- <EditItemTemplate>
- <asp:DropDownList ID="DropDownList14" runat="server"
- SelectedValue='<%# Bind("s_tStatus") %>'>
- <asp:ListItem>Seepferdchen</asp:ListItem>
- <asp:ListItem>Nachwuchs</asp:ListItem>
- <asp:ListItem>Breitensportler</asp:ListItem>
- <asp:ListItem>Leistungssportler</asp:ListItem>
- <asp:ListItem>Masters</asp:ListItem>
- </asp:DropDownList>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("s_tStatus") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label2" runat="server" Text='<%# Bind("s_tStatus") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ButtonType="Image"
- CancelImageUrl="~/Zentral/Cancel.png" DeleteImageUrl="~/Zentral/Delete.png"
- EditImageUrl="~/Zentral/Edit.png" NewImageUrl="~/Zentral/New.png"
- SelectImageUrl="~/Zentral/Select.png"
- UpdateImageUrl="~/Zentral/Update.png" />
- </Fields>
- <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
- <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
- <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
- </asp:DetailsView>
- <asp:AccessDataSource ID="AccessDataSource3" runat="server"
- ConflictDetection="CompareAllValues"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- DeleteCommand="DELETE FROM [Sportler] WHERE ([m_aNr] = ?)"
- InsertCommand="INSERT INTO [Sportler] ([m_aNr], [s_tFörderung], [s_tStatus]) VALUES (?, ?, ?)"
- OldValuesParameterFormatString="original_{0}"
- SelectCommand="SELECT [m_aNr], [s_tFörderung], [s_tStatus] FROM [Sportler] WHERE ([m_aNr] = ?)"
- UpdateCommand="UPDATE Sportler SET [s_tFörderung] = ?, s_tStatus = ? WHERE (m_aNr = ?)">
- <DeleteParameters>
- <asp:Parameter Name="original_m_aNr" Type="Int32" />
- <asp:Parameter Name="original_s_tFörderung" Type="Int32" />
- <asp:Parameter Name="original_s_tFörderung" Type="Int32" />
- <asp:Parameter Name="original_s_tStatus" Type="String" />
- </DeleteParameters>
- <InsertParameters>
- <asp:Parameter Name="m_aNr" Type="Int32" />
- <asp:Parameter Name="s_tFörderung" Type="Int32" />
- <asp:Parameter Name="s_tStatus" Type="String" />
- </InsertParameters>
- <SelectParameters>
- <asp:ControlParameter ControlID="DropDownList1" Name="m_aNr"
- PropertyName="SelectedValue" Type="Int32" />
- </SelectParameters>
- <UpdateParameters>
- <asp:Parameter Name="s_tFörderung" Type="Int32" />
- <asp:Parameter Name="s_tStatus" Type="String" />
- <asp:Parameter Name="original_m_aNr" Type="Int32" />
- <asp:Parameter Name="original_s_tFörderung" Type="Int32" />
- <asp:Parameter Name="original_s_tFörderung" Type="Int32" />
- <asp:Parameter Name="original_s_tStatus" Type="String" />
- </UpdateParameters>
- </asp:AccessDataSource>
- <asp:DetailsView ID="DetailsView10" runat="server" AutoGenerateRows="False"
- BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
- CellPadding="3" DataSourceID="AccessDataSource6"
- DefaultMode="Insert" GridLines="Vertical" Height="50px"
- oniteminserted="DetailsView10_ItemInserted" Width="250px">
- <AlternatingRowStyle BackColor="#DCDCDC" />
- <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
- <Fields>
- <asp:TemplateField HeaderText="m-Nr" SortExpression="m_aNr">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("m_aNr") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("m_aNr") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("m_aNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Förderung" SortExpression="s_tFörderung">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("s_tFörderung") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server"
- Text='<%# Bind("s_tFörderung", "{0:N}") %>'></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator25" runat="server"
- ControlToValidate="TextBox2" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:CompareValidator ID="CompareValidator10" runat="server"
- ControlToValidate="TextBox2" Display="Dynamic" ErrorMessage="Falsches Format"
- Operator="DataTypeCheck" Type="Currency"></asp:CompareValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label2" runat="server" Text='<%# Bind("s_tFörderung") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Status" SortExpression="s_tStatus">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("s_tStatus") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList10" runat="server"
- AppendDataBoundItems="True" SelectedValue='<%# Bind("s_tStatus") %>'>
- <asp:ListItem>Seepferdchen</asp:ListItem>
- <asp:ListItem>Nachwuchs</asp:ListItem>
- <asp:ListItem>Breitensportler</asp:ListItem>
- <asp:ListItem>Leistungssportler</asp:ListItem>
- <asp:ListItem>Masters</asp:ListItem>
- </asp:DropDownList>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label3" runat="server" Text='<%# Bind("s_tStatus") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CommandField ShowInsertButton="True" ButtonType="Image"
- CancelImageUrl="~/Zentral/Cancel.png" InsertImageUrl="~/Zentral/Insert.png" />
- </Fields>
- <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
- <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
- <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
- </asp:DetailsView>
- <asp:AccessDataSource ID="AccessDataSource6" runat="server"
- ConflictDetection="CompareAllValues"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- InsertCommand="INSERT INTO Sportler(m_aNr, [s_tFörderung], s_tStatus) VALUES (?, ?, ?)"
- OldValuesParameterFormatString="original_{0}"
- SelectCommand="SELECT Sportler.[s_tFörderung], Sportler.s_tStatus, Mitglied.m_aNr AS Expr1, Sportler.m_aNr FROM (Sportler INNER JOIN Mitglied ON Sportler.m_aNr = Mitglied.m_aNr) WHERE (Mitglied.m_aNr = ?)">
- <InsertParameters>
- <asp:Parameter Name="m_aNr" Type="Int32" />
- <asp:Parameter Name="s_tFörderung" Type="Int32" />
- <asp:Parameter Name="s_tStatus" Type="String" />
- </InsertParameters>
- <SelectParameters>
- <asp:ControlParameter ControlID="DropDownList1" Name="m_aNr"
- PropertyName="SelectedValue" Type="Int32" />
- </SelectParameters>
- </asp:AccessDataSource>
- </td>
- <td width="300" align="center" valign="top">
- <asp:CheckBox ID="CheckBox2" runat="server" Text="Ist Trainer"
- TextAlign="Left"
- style="font-weight: 700; text-decoration: underline; font-size: medium"
- AutoPostBack="True" oncheckedchanged="CheckBox2_CheckedChanged" />
- <br />
- <br />
- <asp:DetailsView ID="DetailsView7" runat="server" AutoGenerateRows="False"
- DataSourceID="AccessDataSource4" Height="50px" Width="250px"
- DataKeyNames="m_aNr" BackColor="White" BorderColor="#999999"
- BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical"
- ondatabound="DetailsView7_DataBound">
- <AlternatingRowStyle BackColor="#DCDCDC" />
- <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
- <Fields>
- <asp:TemplateField HeaderText="m-Nr" SortExpression="m_aNr">
- <EditItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Eval("m_aNr") %>'></asp:Label>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("m_aNr") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label4" runat="server" Text='<%# Bind("m_aNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Gehalt" SortExpression="t_zGehalt">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server"
- Text='<%# Bind("t_zGehalt", "{0:N}") %>'></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator30" runat="server"
- ControlToValidate="TextBox2" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:CompareValidator ID="CompareValidator11" runat="server"
- ControlToValidate="TextBox2" Display="Dynamic" ErrorMessage="Falsches Format"
- Operator="DataTypeCheck" Type="Currency"></asp:CompareValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("t_zGehalt") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label3" runat="server" Text='<%# Bind("t_zGehalt", "{0:N}") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Lizenz" SortExpression="t_tLizenz">
- <EditItemTemplate>
- <asp:DropDownList ID="DropDownList15" runat="server" Height="18px"
- SelectedValue='<%# Bind("t_tLizenz") %>' Width="128px">
- <asp:ListItem>Trainerassistent</asp:ListItem>
- <asp:ListItem>C-Trainer</asp:ListItem>
- <asp:ListItem>B-Trainer</asp:ListItem>
- <asp:ListItem>A-Trainer</asp:ListItem>
- </asp:DropDownList>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("t_tLizenz") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label2" runat="server" Text='<%# Bind("t_tLizenz") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Abteilung" SortExpression="t_ab_aNr">
- <EditItemTemplate>
- <asp:DropDownList ID="DropDownList2" runat="server"
- DataSourceID="AccessDataSource1" DataTextField="ab_tName"
- DataValueField="ab_aNr" SelectedValue='<%# Bind("ab_aNr") %>'>
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource1" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- SelectCommand="SELECT [ab_aNr], [ab_tName] FROM [Abteilung]">
- </asp:AccessDataSource>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList3" runat="server"
- DataSourceID="AccessDataSource1" DataTextField="ab_tName"
- DataValueField="ab_aNr" SelectedValue='<%# Bind("ab_aNr") %>'>
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource1" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- SelectCommand="SELECT [ab_aNr], [ab_tName] FROM [Abteilung]">
- </asp:AccessDataSource>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("t_ab_aNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ButtonType="Image"
- CancelImageUrl="~/Zentral/Cancel.png" DeleteImageUrl="~/Zentral/Delete.png"
- EditImageUrl="~/Zentral/Edit.png" NewImageUrl="~/Zentral/New.png"
- SelectImageUrl="~/Zentral/Select.png"
- UpdateImageUrl="~/Zentral/Update.png" />
- </Fields>
- <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
- <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
- <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
- </asp:DetailsView>
- <asp:AccessDataSource ID="AccessDataSource4" runat="server"
- ConflictDetection="CompareAllValues"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- DeleteCommand="DELETE FROM [Trainer] WHERE ([m_aNr] = ?)"
- InsertCommand="INSERT INTO [Trainer] ([m_aNr], [t_zGehalt], [t_tLizenz], [ab_aNr]) VALUES (?, ?, ?, ?)"
- OldValuesParameterFormatString="original_{0}"
- SelectCommand="SELECT Trainer.m_aNr, Trainer.t_zGehalt, Trainer.t_tLizenz, Trainer.ab_aNr AS t_ab_aNr, Abteilung.ab_aNr, Abteilung.ab_tName FROM (Trainer INNER JOIN Abteilung ON Trainer.ab_aNr = Abteilung.ab_aNr) WHERE (Trainer.m_aNr = ?)"
- UpdateCommand="UPDATE Trainer SET t_zGehalt = ?, t_tLizenz = ?, ab_aNr = ? WHERE (m_aNr = ?)">
- <DeleteParameters>
- <asp:Parameter Name="original_m_aNr" Type="Int32" />
- <asp:Parameter Name="original_t_zGehalt" Type="Decimal" />
- <asp:Parameter Name="original_t_tLizenz" Type="String" />
- <asp:Parameter Name="original_ab_aNr" Type="Int32" />
- </DeleteParameters>
- <InsertParameters>
- <asp:Parameter Name="m_aNr" Type="Int32" />
- <asp:Parameter Name="t_zGehalt" Type="Decimal" />
- <asp:Parameter Name="t_tLizenz" Type="String" />
- <asp:Parameter Name="ab_aNr" Type="Int32" />
- </InsertParameters>
- <SelectParameters>
- <asp:ControlParameter ControlID="DropDownList1" Name="m_aNr"
- PropertyName="SelectedValue" Type="Int32" />
- </SelectParameters>
- <UpdateParameters>
- <asp:Parameter Name="t_zGehalt" Type="Decimal" />
- <asp:Parameter Name="t_tLizenz" Type="String" />
- <asp:Parameter Name="ab_aNr" Type="Int32" />
- <asp:Parameter Name="original_m_aNr" Type="Int32" />
- <asp:Parameter Name="original_t_zGehalt" Type="Decimal" />
- <asp:Parameter Name="original_t_tLizenz" Type="String" />
- <asp:Parameter Name="original_ab_aNr" Type="Int32" />
- </UpdateParameters>
- </asp:AccessDataSource>
- <asp:DetailsView ID="DetailsView11" runat="server" AutoGenerateRows="False"
- BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
- CellPadding="3" DataSourceID="AccessDataSource7" DefaultMode="Insert"
- GridLines="Vertical" Height="50px" oniteminserted="DetailsView11_ItemInserted"
- Width="250px">
- <AlternatingRowStyle BackColor="#DCDCDC" />
- <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
- <Fields>
- <asp:BoundField DataField="m_aNr" HeaderText="m-Nr" SortExpression="m_aNr" />
- <asp:TemplateField HeaderText="Gehalt in €" SortExpression="t_zGehalt">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("t_zGehalt") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server"
- Text='<%# Bind("t_zGehalt", "{0:N}") %>'></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator26" runat="server"
- ControlToValidate="TextBox1" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- <br />
- <asp:CompareValidator ID="CompareValidator12" runat="server"
- ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="Falsches Format"
- Operator="DataTypeCheck" Type="Currency"></asp:CompareValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label2" runat="server" Text='<%# Bind("t_zGehalt") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Lizenz" SortExpression="t_tLizenz">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("t_tLizenz") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList16" runat="server"
- SelectedValue='<%# Bind("t_tLizenz") %>'>
- <asp:ListItem>Trainerassistent</asp:ListItem>
- <asp:ListItem>C-Trainer</asp:ListItem>
- <asp:ListItem>B-Trainer</asp:ListItem>
- <asp:ListItem>A-Trainer</asp:ListItem>
- </asp:DropDownList>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label3" runat="server" Text='<%# Bind("t_tLizenz") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Abteilung" SortExpression="ab_aNr">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ab_aNr") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList8" runat="server"
- DataSourceID="AccessDataSource1" DataTextField="ab_tName"
- DataValueField="ab_aNr" SelectedValue='<%# Bind("ab_aNr") %>'>
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource1" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- SelectCommand="SELECT [ab_aNr], [ab_tName] FROM [Abteilung]">
- </asp:AccessDataSource>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("ab_aNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CommandField ShowInsertButton="True" ButtonType="Image"
- CancelImageUrl="~/Zentral/Cancel.png" InsertImageUrl="~/Zentral/Insert.png" />
- </Fields>
- <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
- <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
- <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
- </asp:DetailsView>
- <asp:AccessDataSource ID="AccessDataSource7" runat="server"
- ConflictDetection="CompareAllValues"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- InsertCommand="INSERT INTO [Trainer] ([t_zGehalt], [m_aNr], [t_tLizenz], [ab_aNr]) VALUES (?, ?, ?, ?)"
- OldValuesParameterFormatString="original_{0}"
- SelectCommand="SELECT Trainer.t_zGehalt, Trainer.m_aNr, Trainer.t_tLizenz, Trainer.ab_aNr, Abteilung.ab_aNr AS Expr1, Abteilung.ab_tName FROM (Trainer INNER JOIN Abteilung ON Trainer.ab_aNr = Abteilung.ab_aNr) WHERE (Trainer.m_aNr = ?)">
- <InsertParameters>
- <asp:Parameter Name="t_zGehalt" Type="Decimal" />
- <asp:Parameter Name="m_aNr" Type="Int32" />
- <asp:Parameter Name="t_tLizenz" Type="String" />
- <asp:Parameter Name="ab_aNr" Type="Int32" />
- </InsertParameters>
- <SelectParameters>
- <asp:ControlParameter ControlID="DropDownList1" Name="m_aNr"
- PropertyName="SelectedValue" Type="Int32" />
- </SelectParameters>
- </asp:AccessDataSource>
- </td>
- <td width="315" align="center" valign="top">
- <asp:CheckBox ID="CheckBox3" runat="server"
- style="font-weight: 700; text-decoration: underline; font-size: medium"
- Text="Ist in Abteilungsleitung" TextAlign="Left" AutoPostBack="True"
- oncheckedchanged="CheckBox3_CheckedChanged" />
- <br />
- <br />
- <asp:DetailsView ID="DetailsView8" runat="server" AutoGenerateRows="False"
- DataSourceID="AccessDataSource5" Height="50px" Width="250px"
- BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
- CellPadding="3" GridLines="Vertical" ondatabound="DetailsView8_DataBound">
- <AlternatingRowStyle BackColor="#DCDCDC" />
- <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
- <Fields>
- <asp:BoundField DataField="m_aNr" HeaderText="m-Nr" SortExpression="m_aNr" />
- <asp:TemplateField HeaderText="Position" SortExpression="abl_tPosition">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("abl_tPosition") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator31" runat="server"
- ControlToValidate="TextBox1" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("abl_tPosition") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label2" runat="server" Text='<%# Bind("abl_tPosition") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Vertreter" SortExpression="abl_tVertreter">
- <EditItemTemplate>
- <asp:DropDownList ID="DropDownList17" runat="server"
- DataSourceID="AccessDataSource10" DataTextField="m_tName"
- DataValueField="m_aNr" Height="16px"
- SelectedValue='<%# Bind("abl_tVertreter") %>' Width="128px">
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource10" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- SelectCommand="SELECT Abteilungsleitung.m_aNr, Mitglied.m_tName FROM (Mitglied INNER JOIN Abteilungsleitung ON Mitglied.m_aNr = Abteilungsleitung.m_aNr)"
- UpdateCommand="UPDATE Abteilungsleitung SET abl_tVertreter = ?">
- </asp:AccessDataSource>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("abl_tVertreter") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label3" runat="server" Text='<%# Bind("abl_tVertreter") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CheckBoxField DataField="abl_bStimmrecht" HeaderText="Stimmrecht"
- SortExpression="abl_bStimmrecht" />
- <asp:CheckBoxField DataField="abl_bUnterschrift" HeaderText="Unterschrift"
- SortExpression="abl_bUnterschrift" />
- <asp:TemplateField HeaderText="Abteilung" SortExpression="ab_aNr">
- <EditItemTemplate>
- <asp:DropDownList ID="DropDownList5" runat="server"
- DataSourceID="AccessDataSource1" DataTextField="ab_tName"
- DataValueField="ab_aNr" SelectedValue='<%# Bind("ab_aNr") %>'>
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource1" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- SelectCommand="SELECT [ab_aNr], [ab_tName] FROM [Abteilung]">
- </asp:AccessDataSource>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList4" runat="server"
- DataSourceID="AccessDataSource1" DataTextField="ab_tName"
- DataValueField="ab_aNr" SelectedValue='<%# Bind("ab_aNr") %>'>
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource1" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- SelectCommand="SELECT [ab_aNr], [ab_tName] FROM [Abteilung]">
- </asp:AccessDataSource>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("ab_aNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ButtonType="Image"
- CancelImageUrl="~/Zentral/Cancel.png" DeleteImageUrl="~/Zentral/Delete.png"
- EditImageUrl="~/Zentral/Edit.png" NewImageUrl="~/Zentral/New.png"
- SelectImageUrl="~/Zentral/Select.png"
- UpdateImageUrl="~/Zentral/Update.png" />
- </Fields>
- <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
- <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
- <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
- </asp:DetailsView>
- <asp:AccessDataSource ID="AccessDataSource5" runat="server"
- ConflictDetection="CompareAllValues"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- DeleteCommand="DELETE FROM [Abteilungsleitung] WHERE ([m_aNr] = ?)"
- InsertCommand="INSERT INTO [Abteilungsleitung] ([m_aNr], [abl_tPosition], [abl_bStimmrecht], [abl_tVertreter], [abl_bUnterschrift], [ab_aNr]) VALUES (?, ?, ?, ?, ?, ?)"
- OldValuesParameterFormatString="original_{0}"
- SelectCommand="SELECT Abteilungsleitung.m_aNr, Abteilungsleitung.abl_tPosition, Abteilungsleitung.abl_bStimmrecht, Abteilungsleitung.abl_tVertreter, Abteilungsleitung.abl_bUnterschrift, Abteilungsleitung.ab_aNr, Abteilung.ab_aNr AS Expr1, Abteilung.ab_tName FROM (Abteilungsleitung INNER JOIN Abteilung ON Abteilungsleitung.ab_aNr = Abteilung.ab_aNr) WHERE (Abteilungsleitung.m_aNr = ?)"
- UpdateCommand="UPDATE Abteilungsleitung SET abl_tPosition = ?, abl_bStimmrecht = ?, abl_tVertreter = ?, abl_bUnterschrift = ?, ab_aNr = ? WHERE (m_aNr = ?)">
- <DeleteParameters>
- <asp:Parameter Name="original_m_aNr" Type="Int32" />
- <asp:Parameter Name="original_abl_tPosition" Type="String" />
- <asp:Parameter Name="original_abl_bStimmrecht" Type="Boolean" />
- <asp:Parameter Name="original_abl_tVertreter" Type="String" />
- <asp:Parameter Name="original_abl_bUnterschrift" Type="Boolean" />
- <asp:Parameter Name="original_ab_aNr" Type="Int32" />
- </DeleteParameters>
- <InsertParameters>
- <asp:Parameter Name="m_aNr" Type="Int32" />
- <asp:Parameter Name="abl_tPosition" Type="String" />
- <asp:Parameter Name="abl_bStimmrecht" Type="Boolean" />
- <asp:Parameter Name="abl_tVertreter" Type="String" />
- <asp:Parameter Name="abl_bUnterschrift" Type="Boolean" />
- <asp:Parameter Name="ab_aNr" Type="Int32" />
- </InsertParameters>
- <SelectParameters>
- <asp:ControlParameter ControlID="DropDownList1" Name="m_aNr"
- PropertyName="SelectedValue" Type="Int32" />
- </SelectParameters>
- <UpdateParameters>
- <asp:Parameter Name="abl_tPosition" Type="String" />
- <asp:Parameter Name="abl_bStimmrecht" Type="Boolean" />
- <asp:Parameter Name="abl_tVertreter" Type="String" />
- <asp:Parameter Name="abl_bUnterschrift" Type="Boolean" />
- <asp:Parameter Name="ab_aNr" Type="Int32" />
- <asp:Parameter Name="original_m_aNr" Type="Int32" />
- <asp:Parameter Name="original_abl_tPosition" Type="String" />
- <asp:Parameter Name="original_abl_bStimmrecht" Type="Boolean" />
- <asp:Parameter Name="original_abl_tVertreter" Type="String" />
- <asp:Parameter Name="original_abl_bUnterschrift" Type="Boolean" />
- <asp:Parameter Name="original_ab_aNr" Type="Int32" />
- </UpdateParameters>
- </asp:AccessDataSource>
- <asp:DetailsView ID="DetailsView12" runat="server" AutoGenerateRows="False"
- BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
- CellPadding="3" DataKeyNames="m_aNr" DataSourceID="AccessDataSource8"
- DefaultMode="Insert" GridLines="Vertical" Height="50px"
- oniteminserted="DetailsView12_ItemInserted" Width="125px">
- <AlternatingRowStyle BackColor="#DCDCDC" />
- <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
- <Fields>
- <asp:TemplateField HeaderText="m-Nr" SortExpression="m_aNr">
- <EditItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Eval("m_aNr") %>'></asp:Label>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("m_aNr") %>'></asp:TextBox>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label3" runat="server" Text='<%# Bind("m_aNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:TemplateField HeaderText="Position" SortExpression="abl_tPosition">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("abl_tPosition") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("abl_tPosition") %>'
- MaxLength="30"></asp:TextBox>
- <br />
- <asp:RequiredFieldValidator ID="RequiredFieldValidator28" runat="server"
- ControlToValidate="TextBox1" Display="Dynamic"
- ErrorMessage="RequiredFieldValidator">Eingabe erforderlich</asp:RequiredFieldValidator>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label2" runat="server" Text='<%# Bind("abl_tPosition") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CheckBoxField DataField="abl_bStimmrecht" HeaderText="Stimmrecht"
- SortExpression="abl_bStimmrecht" />
- <asp:TemplateField HeaderText="Vertreter" SortExpression="abl_tVertreter">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("abl_tVertreter") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList13" runat="server"
- DataSourceID="AccessDataSource9" DataTextField="m_tName" DataValueField="m_aNr"
- Height="20px" SelectedValue='<%# Bind("abl_tVertreter") %>' Width="129px">
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource9" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- InsertCommand="INSERT INTO Abteilungsleitung(m_aNr) VALUES ()"
- SelectCommand="SELECT Abteilungsleitung.m_aNr, Mitglied.m_tName FROM (Mitglied INNER JOIN Abteilungsleitung ON Mitglied.m_aNr = Abteilungsleitung.m_aNr)">
- </asp:AccessDataSource>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label4" runat="server" Text='<%# Bind("abl_tVertreter") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CheckBoxField DataField="abl_bUnterschrift" HeaderText="Unterschrift"
- SortExpression="abl_bUnterschrift" />
- <asp:TemplateField HeaderText="Abteilung" SortExpression="ab_aNr">
- <EditItemTemplate>
- <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ab_aNr") %>'></asp:TextBox>
- </EditItemTemplate>
- <InsertItemTemplate>
- <asp:DropDownList ID="DropDownList9" runat="server"
- DataSourceID="AccessDataSource1" DataTextField="ab_tName"
- DataValueField="ab_aNr" SelectedValue='<%# Bind("ab_aNr") %>'>
- </asp:DropDownList>
- <asp:AccessDataSource ID="AccessDataSource1" runat="server"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- SelectCommand="SELECT [ab_aNr], [ab_tName] FROM [Abteilung]">
- </asp:AccessDataSource>
- </InsertItemTemplate>
- <ItemTemplate>
- <asp:Label ID="Label1" runat="server" Text='<%# Bind("ab_aNr") %>'></asp:Label>
- </ItemTemplate>
- </asp:TemplateField>
- <asp:CommandField ShowInsertButton="True" ButtonType="Image"
- CancelImageUrl="~/Zentral/Cancel.png" InsertImageUrl="~/Zentral/Insert.png" />
- </Fields>
- <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
- <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
- <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
- </asp:DetailsView>
- <asp:AccessDataSource ID="AccessDataSource8" runat="server"
- ConflictDetection="CompareAllValues"
- DataFile="~/App_Data/Mitgliederverwaltung des Berliner TSC.accdb"
- InsertCommand="INSERT INTO [Abteilungsleitung] ([abl_tPosition], [abl_bStimmrecht], [m_aNr], [abl_tVertreter], [ab_aNr], [abl_bUnterschrift]) VALUES (?, ?, ?, ?, ?, ?)"
- OldValuesParameterFormatString="original_{0}"
- SelectCommand="SELECT Abteilungsleitung.abl_tPosition, Abteilungsleitung.abl_bStimmrecht, Abteilungsleitung.m_aNr, Abteilungsleitung.abl_tVertreter, Abteilungsleitung.ab_aNr, Abteilungsleitung.abl_bUnterschrift, Abteilung.ab_aNr AS Expr1, Abteilung.ab_tName FROM (Abteilungsleitung INNER JOIN Abteilung ON Abteilungsleitung.ab_aNr = Abteilung.ab_aNr) WHERE (Abteilungsleitung.m_aNr = ?)">
- <InsertParameters>
- <asp:Parameter Name="abl_tPosition" Type="String" />
- <asp:Parameter Name="abl_bStimmrecht" Type="Boolean" />
- <asp:Parameter Name="m_aNr" Type="Int32" />
- <asp:Parameter Name="abl_tVertreter" Type="String" />
- <asp:Parameter Name="ab_aNr" Type="Int32" />
- <asp:Parameter Name="abl_bUnterschrift" Type="Boolean" />
- </InsertParameters>
- <SelectParameters>
- <asp:ControlParameter ControlID="DropDownList1" Name="m_aNr"
- PropertyName="SelectedValue" Type="Int32" />
- </SelectParameters>
- </asp:AccessDataSource>
- </td>
- </tr>
- </table>
- </asp:Content>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement