Hi,

I use an ASPxGridView to show data from multiple tables with an inner join query. I use a stored procedure to update these datas from multiple tables.

I created a SqlDataSource to bind them to ASPxGridView.

But, when I click to Edit button which is created by Columns in the smart tag of ASPxGridView, Nothing happens...

I had two columns which are not used in stored procedure. For testing, I deleted them and try again, but still It did not work.

Can anyone inform me about the details of binding stored procedures to ASPxGridView using SqlDataSource to use Edit fuction

and instruct me about what to do?

Thank you very much.

Arda

My ASPxGridView and SqlDataSource code is below:

<dxwgv:ASPxGridView ID="ASPxGridView1" runat="server" 

            AutoGenerateColumns="False" DataSourceID="KullanicilarDataSource">

            <Columns>

<dxwgv:GridViewCommandColumn VisibleIndex="0">

<EditButton Visible="True">

</EditButton>

</dxwgv:GridViewCommandColumn>

<dxwgv:GridViewDataTextColumn FieldName="UserId" VisibleIndex="0" 

ReadOnly="True">

</dxwgv:GridViewDataTextColumn>

<dxwgv:GridViewDataTextColumn FieldName="UserName" VisibleIndex="2">

</dxwgv:GridViewDataTextColumn>

<dxwgv:GridViewDataTextColumn FieldName="Ad" VisibleIndex="3">

</dxwgv:GridViewDataTextColumn>

<dxwgv:GridViewDataTextColumn FieldName="Soyad" VisibleIndex="4">

</dxwgv:GridViewDataTextColumn>

<dxwgv:GridViewDataTextColumn FieldName="TelefonNo" VisibleIndex="5">

</dxwgv:GridViewDataTextColumn>

<dxwgv:GridViewDataTextColumn FieldName="TCKimlikNo" VisibleIndex="6">

</dxwgv:GridViewDataTextColumn>

<dxwgv:GridViewDataTextColumn FieldName="Adres" VisibleIndex="7">

</dxwgv:GridViewDataTextColumn>

<dxwgv:GridViewDataTextColumn FieldName="LoweredEmail" VisibleIndex="8">

</dxwgv:GridViewDataTextColumn>

<dxwgv:GridViewDataCheckColumn FieldName="IsLockedOut" VisibleIndex="9">

</dxwgv:GridViewDataCheckColumn>

<dxwgv:GridViewDataDateColumn FieldName="CreateDate" VisibleIndex="10" 

ReadOnly="True">

</dxwgv:GridViewDataDateColumn>

<dxwgv:GridViewDataDateColumn FieldName="LastLoginDate" VisibleIndex="11" 

ReadOnly="True">

</dxwgv:GridViewDataDateColumn>

</Columns>

            <Settings ShowFilterRow="True" />

        </dxwgv:ASPxGridView>

        <asp:SqlDataSource ID="KullanicilarDataSource" runat="server" 

            ConnectionString="<%$ ConnectionStrings:DemoConnectionString %>" 

SelectCommand="SELECT aspnet_Users.UserId, aspnet_Users.UserName, KullaniciProfiller.Ad, KullaniciProfiller.Soyad, KullaniciProfiller.TelefonNo, KullaniciProfiller.TCKimlikNo, KullaniciProfiller.Adres, aspnet_Membership.LoweredEmail, aspnet_Membership.IsLockedOut, aspnet_Membership.CreateDate, aspnet_Membership.LastLoginDate FROM aspnet_Users INNER JOIN KullaniciProfiller ON aspnet_Users.UserId = KullaniciProfiller.KullaniciID INNER JOIN aspnet_Membership ON aspnet_Users.UserId = aspnet_Membership.UserId" 

UpdateCommand="KullaniciGuncelle" UpdateCommandType="StoredProcedure">

<UpdateParameters>

<asp:Parameter Name="UserId" Type="Object" />

<asp:Parameter Name="UserName" Type="String" />

<asp:Parameter Name="Ad" Type="String" />

<asp:Parameter Name="Soyad" Type="String" />

<asp:Parameter Name="TelefonNo" Type="Int64" />

<asp:Parameter Name="TCKimlikNo" Type="Int64" />

<asp:Parameter Name="Adres" Type="String" />

<asp:Parameter Name="Email" Type="String" />

<asp:Parameter Name="IsLockedOut" Type="Boolean" />

</UpdateParameters>

        </asp:SqlDataSource>