<form id="form1" runat="server">
    <div>
 
        Kundenverwaltung
        <asp:Button ID="Button1" runat="server" Text="neuen Kunden anlegen" 
            PostBackUrl="~/WebForm1.aspx" />
 
 
        <div>
        <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" _
          ConnectionString="Server=localhost;User" & _
          "ID=xxxxxx;Password=xxxxxxx;Persist Security" & _
          "Info=True;Database=ASPTestDB"
            DeleteCommand="DELETE FROM kunden WHERE kid = @kid" 
            InsertCommand="INSERT INTO kunden (Vorname, Nachname) VALUES (" & _
              "@Vorname, @Nachname)"
            SelectCommand="SELECT * FROM kunden" 
 
                UpdateCommand="UPDATE kunden SET Vorname = @Vorname, Nachname =" & _
                  "@Nachname WHERE kid = @kid" 
                ProviderName="MySql.Data.MySqlClient">
            <DeleteParameters>
                <asp:Parameter Name="kid" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="kid" />
                <asp:Parameter Name="Vorname" Type="String" />
                <asp:Parameter Name="Nachname" Type="String" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="Vorname" Type="String" />
                <asp:Parameter Name="Nachname" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>
 
    </div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" _
          BackColor="White"
            DataSourceID="SqlDataSource1">
            <FooterStyle BackColor="#CCCC99" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ButtonType="Button" 
                    DeleteText="löschen" ShowEditButton="True" />
                <asp:BoundField DataField="kid" HeaderText="kid" _
                  InsertVisible="False" ReadOnly="True"
                    SortExpression="kid" ConvertEmptyStringToNull="False" />
                <asp:BoundField DataField="Vorname" HeaderText="Vorname" _
                  SortExpression="Vorname" />
                <asp:BoundField DataField="Nachname" HeaderText="Nachname" _
                SortExpression="Nachname" />
            </Columns>
            <RowStyle BackColor="#F7F7DE" />
            <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" _
              ForeColor="White" />
            <PagerStyle BackColor="#F7F7DE" ForeColor="Black" _
            HorizontalAlign="Right" />
            <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
            <br />
            <br />
        </div>
 
    </div>
    </form>

-------------------------------
LG
f34rless


Visual Studio 2008 Proffesional
-------------------------------

Beitrag wurde zuletzt am 13.05.09 um 12:51:51 editiert.