Hi friedns,

i'm trying to design my homepage.

My Database has abou 30 columns and i would like to show all them on one page.

3 columns, 1 column = 10 fields.

So i created a table with 3 columns in 1 row. I paste in each column one detailsview, each detailsview has his one datasource.

Datasource 2 and 3 are linked to Datasource1 so if i aktivated paging an go trought the records i see always all fields form one record in all detailsview.

My Problem is the buttons edit,new and delete. I activited this buttons only in datasource1 and if i wnat to edit one record i can only edit in the datasource1. I would like to make it global so if i klick on edit all three detailview should be editable.

Can somebody help me? maybe i have to recreate all my building?

here is my sourcecode:

<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="details.aspx.vb" Inherits="details" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 100%">
        <tr>
            <td>
                <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" 
                    AutoGenerateRows="False" DataKeyNames="ID" DataSourceID="SqlDataSource1" 
                    Height="50px" Width="125px">
                    <Fields>
                        <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
                        <asp:BoundField DataField="vorname" HeaderText="vorname" 
                            SortExpression="vorname" />
                        <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" 
                            ReadOnly="True" SortExpression="ID" />
                        <asp:BoundField DataField="anrede" HeaderText="anrede" 
                            SortExpression="anrede" />
                        <asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
                        <asp:BoundField DataField="strasse" HeaderText="strasse" 
                            SortExpression="strasse" />
                        <asp:BoundField DataField="plz" HeaderText="plz" SortExpression="plz" />
                        <asp:BoundField DataField="ort" HeaderText="ort" SortExpression="ort" />
                        <asp:BoundField DataField="telefon" HeaderText="telefon" 
                            SortExpression="telefon" />
                        <asp:BoundField DataField="telefax" HeaderText="telefax" 
                            SortExpression="telefax" />
                        <asp:BoundField DataField="mobil" HeaderText="mobil" SortExpression="mobil" />
                        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 
                            ShowInsertButton="True" />
                    </Fields>
                </asp:DetailsView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConflictDetection="CompareAllValues" 
                    ConnectionString="<%$ ConnectionStrings:freelancerberConnectionString %>" 
                    DeleteCommand="DELETE FROM [freelancer] WHERE [ID] = @original_ID AND (([name] = @original_name) OR ([name] IS NULL AND @original_name IS NULL)) AND (([vorname] = @original_vorname) OR ([vorname] IS NULL AND @original_vorname IS NULL)) AND (([anrede] = @original_anrede) OR ([anrede] IS NULL AND @original_anrede IS NULL)) AND (( = @original_email) OR ( IS NULL AND @original_email IS NULL)) AND (([strasse] = @original_strasse) OR ([strasse] IS NULL AND @original_strasse IS NULL)) AND (([plz] = @original_plz) OR ([plz] IS NULL AND @original_plz IS NULL)) AND (([ort] = @original_ort) OR ([ort] IS NULL AND @original_ort IS NULL)) AND (([telefon] = @original_telefon) OR ([telefon] IS NULL AND @original_telefon IS NULL)) AND (([telefax] = @original_telefax) OR ([telefax] IS NULL AND @original_telefax IS NULL)) AND (([mobil] = @original_mobil) OR ([mobil] IS NULL AND @original_mobil IS NULL))" 
                    InsertCommand="INSERT INTO [freelancer] ([name], [vorname], [anrede], , [strasse], [plz], [ort], [telefon], [telefax], [mobil]) VALUES (@name, @vorname, @anrede, @email, @strasse, @plz, @ort, @telefon, @telefax, @mobil)" 
                    OldValuesParameterFormatString="original_{0}" 
                    SelectCommand="SELECT [name], [vorname], [ID], [anrede], , [strasse], [plz], [ort], [telefon], [telefax], [mobil] FROM [freelancer]" 
                    UpdateCommand="UPDATE [freelancer] SET [name] = @name, [vorname] = @vorname, [anrede] = @anrede,  = @email, [strasse] = @strasse, [plz] = @plz, [ort] = @ort, [telefon] = @telefon, [telefax] = @telefax, [mobil] = @mobil WHERE [ID] = @original_ID AND (([name] = @original_name) OR ([name] IS NULL AND @original_name IS NULL)) AND (([vorname] = @original_vorname) OR ([vorname] IS NULL AND @original_vorname IS NULL)) AND (([anrede] = @original_anrede) OR ([anrede] IS NULL AND @original_anrede IS NULL)) AND (( = @original_email) OR ( IS NULL AND @original_email IS NULL)) AND (([strasse] = @original_strasse) OR ([strasse] IS NULL AND @original_strasse IS NULL)) AND (([plz] = @original_plz) OR ([plz] IS NULL AND @original_plz IS NULL)) AND (([ort] = @original_ort) OR ([ort] IS NULL AND @original_ort IS NULL)) AND (([telefon] = @original_telefon) OR ([telefon] IS NULL AND @original_telefon IS NULL)) AND (([telefax] = @original_telefax) OR ([telefax] IS NULL AND @original_telefax IS NULL)) AND (([mobil] = @original_mobil) OR ([mobil] IS NULL AND @original_mobil IS NULL))">
                    <DeleteParameters>
                        <asp:Parameter Name="original_ID" Type="Int32" />
                        <asp:Parameter Name="original_name" Type="String" />
                        <asp:Parameter Name="original_vorname" Type="String" />
                        <asp:Parameter Name="original_anrede" Type="String" />
                        <asp:Parameter Name="original_email" Type="String" />
                        <asp:Parameter Name="original_strasse" Type="String" />
                        <asp:Parameter Name="original_plz" Type="String" />
                        <asp:Parameter Name="original_ort" Type="String" />
                        <asp:Parameter Name="original_telefon" Type="String" />
                        <asp:Parameter Name="original_telefax" Type="String" />
                        <asp:Parameter Name="original_mobil" Type="String" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="name" Type="String" />
                        <asp:Parameter Name="vorname" Type="String" />
                        <asp:Parameter Name="anrede" Type="String" />
                        <asp:Parameter Name="email" Type="String" />
                        <asp:Parameter Name="strasse" Type="String" />
                        <asp:Parameter Name="plz" Type="String" />
                        <asp:Parameter Name="ort" Type="String" />
                        <asp:Parameter Name="telefon" Type="String" />
                        <asp:Parameter Name="telefax" Type="String" />
                        <asp:Parameter Name="mobil" Type="String" />
                        <asp:Parameter Name="original_ID" Type="Int32" />
                        <asp:Parameter Name="original_name" Type="String" />
                        <asp:Parameter Name="original_vorname" Type="String" />
                        <asp:Parameter Name="original_anrede" Type="String" />
                        <asp:Parameter Name="original_email" Type="String" />
                        <asp:Parameter Name="original_strasse" Type="String" />
                        <asp:Parameter Name="original_plz" Type="String" />
                        <asp:Parameter Name="original_ort" Type="String" />
                        <asp:Parameter Name="original_telefon" Type="String" />
                        <asp:Parameter Name="original_telefax" Type="String" />
                        <asp:Parameter Name="original_mobil" Type="String" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="name" Type="String" />
                        <asp:Parameter Name="vorname" Type="String" />
                        <asp:Parameter Name="anrede" Type="String" />
                        <asp:Parameter Name="email" Type="String" />
                        <asp:Parameter Name="strasse" Type="String" />
                        <asp:Parameter Name="plz" Type="String" />
                        <asp:Parameter Name="ort" Type="String" />
                        <asp:Parameter Name="telefon" Type="String" />
                        <asp:Parameter Name="telefax" Type="String" />
                        <asp:Parameter Name="mobil" Type="String" />
                    </InsertParameters>
                </asp:SqlDataSource>
            </td>
            <td>
                <asp:DetailsView ID="DetailsView2" runat="server" AutoGenerateRows="False" 
                    DataSourceID="SqlDataSource2" Height="50px" Width="125px">
                    <Fields>
                        <asp:BoundField DataField="sonstiges" HeaderText="sonstiges" 
                            SortExpression="sonstiges" />
                        <asp:BoundField DataField="derzeitigefirma" HeaderText="derzeitigefirma" 
                            SortExpression="derzeitigefirma" />
                        <asp:BoundField DataField="position" HeaderText="position" 
                            SortExpression="position" />
                        <asp:BoundField DataField="vkl" HeaderText="vkl" SortExpression="vkl" />
                        <asp:BoundField DataField="partner" HeaderText="partner" 
                            SortExpression="partner" />
                        <asp:BoundField DataField="kundenschwerpunkt" HeaderText="kundenschwerpunkt" 
                            SortExpression="kundenschwerpunkt" />
                        <asp:BoundField DataField="website" HeaderText="website" 
                            SortExpression="website" />
                        <asp:BoundField DataField="sprachen" HeaderText="sprachen" 
                            SortExpression="sprachen" />
                    </Fields>
                </asp:DetailsView>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:freelancerberConnectionString %>" 
                    SelectCommand="SELECT [sonstiges], [derzeitigefirma], [position], [vkl], [partner], [kundenschwerpunkt], [website], [sprachen] FROM [freelancer] WHERE ([ID] = @ID)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="DetailsView1" Name="ID" 
                            PropertyName="SelectedValue" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
            <td>
                <asp:DetailsView ID="DetailsView3" runat="server" AutoGenerateRows="False" 
                    DataSourceID="SqlDataSource3" Height="50px" Width="125px">
                    <Fields>
                        <asp:BoundField DataField="eigenerrechner" HeaderText="eigenerrechner" 
                            SortExpression="eigenerrechner" />
                        <asp:BoundField DataField="eingestelltdurch" HeaderText="eingestelltdurch" 
                            SortExpression="eingestelltdurch" />
                        <asp:BoundField DataField="hatgearbeitetfuer" HeaderText="hatgearbeitetfuer" 
                            SortExpression="hatgearbeitetfuer" />
                        <asp:BoundField DataField="tagessatz" HeaderText="tagessatz" 
                            SortExpression="tagessatz" />
                        <asp:BoundField DataField="rabatstaffel" HeaderText="rabatstaffel" 
                            SortExpression="rabatstaffel" />
                        <asp:BoundField DataField="svnummer" HeaderText="svnummer" 
                            SortExpression="svnummer" />
                        <asp:BoundField DataField="unterkunft" HeaderText="unterkunft" 
                            SortExpression="unterkunft" />
                        <asp:BoundField DataField="zuletztaktualisiert" 
                            HeaderText="zuletztaktualisiert" SortExpression="zuletztaktualisiert" />
                        <asp:BoundField DataField="erstellungsdatum" HeaderText="erstellungsdatum" 
                            SortExpression="erstellungsdatum" />
                    </Fields>
                </asp:DetailsView>
                <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:freelancerberConnectionString %>" 
                    SelectCommand="SELECT [eigenerrechner], [eingestelltdurch], [hatgearbeitetfuer], [tagessatz], [rabatstaffel], [svnummer], [unterkunft], [zuletztaktualisiert], [erstellungsdatum] FROM [freelancer]">
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td>
                 </td>
            <td>
                 </td>
            <td>
                 </td>
        </tr>
    </table>
</asp:Content>

For a better undesrtanding i attach a picture auf my layout.

and i would like by klicking on edit or new or delte to slecet all fields and not only the field in the first colum.

Here is the pic : http://www.img-box.de/67124/

No one any idey?

I would like only to split my detailview to recieve 3 column instead of 1 standrad column with all fields?

you could use one detailsview with 3 template fields....so effectively what you have presently with each detailsview would be contained in one template field...something on those lines has been done here: http://www.asp.net/LEARN/data-access/tutorial-13-cs.aspx ...notice the 'Price and Inventory' area

hi,

thank you for your tip, but im not really understand how it will helps me?

Maybe you misunderstood me?

I just want ti split my Detailsview and however have the possibility to edit, create or delet the record by clicking on one button and not in every splitted container.

like here in the pic: http://www.img-box.de/67124/

Hi homermg,

For using multiple DetailsView you can add custom edit Button into DetailsView and handle the same Click event of these edit button to turn to the edit mode for all DetailsView:

Protected Sub EditButton_Click(ByVal sender As Object, ByVal e As EventArgs)
    DetailsView1.ChangeMode(DetailsViewMode.Edit)
    DetailsView1.DataBind()
    DetailsView2.ChangeMode(DetailsViewMode.Edit)
    DetailsView2.DataBind()
    DetailsView3.ChangeMode(DetailsViewMode.Edit)
    DetailsView3.DataBind()
End Sub

I suggest you can use MultiView control to create a editor form to update the data:

http://www.tutorialized.com/view/tutorial/Multi-page-forms-with-MultiView-control-in-ASP.NET/40455

http://www.codeproject.com/KB/custom-controls/TabControl.aspx

Thanks,