Editing with Radgrid is not ocurring

[griselda sirvent]

Hi,

I am using Radgrid to display/retrieve/update data in an Access database.

Although I am able to delete and addd records, I cannot update.

There are no errors being displayed....I update the field(s) and press OK to accept the changes...but the new changes are not saved..the listing shows again the previous record/field...

As I said, no errors are shown after pressing ok.

Here is the code below (not all, but I assume is where the problem might be?)

II have not changed or added anything manual to the code.

Thank you in advance

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
            DataFile="~/App_Data/Registro_Planchas_be.mdb"
            DeleteCommand="DELETE FROM [Tabla Registro Planchas] WHERE [Nº] = ?"
            InsertCommand="INSERT INTO [Tabla Registro Planchas] ([FECHA], [REFERENCIA], [PROVEEDOR], [REFERENCIA PEDIDO], [MAQUINA], [MARCA], [MEDIDA], [TROQUEL], [DISEÑO]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
            SelectCommand="SELECT * FROM [Tabla Registro Planchas]"
            UpdateCommand="UPDATE [Tabla Registro Planchas] SET [FECHA] = ?, [REFERENCIA] = ?, [PROVEEDOR] = ?, [REFERENCIA PEDIDO] = ?, [MAQUINA] = ?, [MARCA] = ?, [MEDIDA] = ?, [TROQUEL] = ?, [DISEÑO] = ? WHERE [Nº] = ?">
            <DeleteParameters>
                <asp:Parameter Name="Nº" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="FECHA" Type="DateTime" />
                <asp:Parameter Name="REFERENCIA" Type="String" />
                <asp:Parameter Name="PROVEEDOR" Type="String" />
                <asp:Parameter Name="REFERENCIA_PEDIDO" Type="String" />
                <asp:Parameter Name="MAQUINA" Type="String" />
                <asp:Parameter Name="MARCA" Type="String" />
                <asp:Parameter Name="MEDIDA" Type="String" />
                <asp:Parameter Name="TROQUEL" Type="String" />
                <asp:Parameter Name="DISEÑO" Type="String" />
            </UpdateParameters>    <br>            </UpdateParameters>

[Shinu]

Hello Griselda,

Check whether you have set 'AllowAutomaticUpdates' property of RadGrid as 'True'. If not set it as 'true' and check if it works now.

-Shinu.

[griselda sirvent]

Hi

I was hoping it would be that, however I have just checked and I do have allowautomaticupdates set to "true"

Any other ideas what it could be ?

[Princy]

Hello Griselda,

I issue is because of not including the field in where condition in Update pramenter.

ASPX:

<UpdateParameters>

       .  .  . .   .  .


     <asp:Parameter Name="Nº" Type="Int32" />

 </UpdateParameters>

Thanks,
Princy.

[griselda sirvent]

Hi Princy

Thanks for input

Unfortunately that didn't work either

Funny thing is that I don't get any type of errors....everything runs "like" if was working...only that record doesn't get updated...:)

You can see for yourselves in this temporary site:

http://www.xcelente.net

and here is the code...

http://www.xcelente.net/asptempsite.txt

Just do an update on any of the records...nothing happens

very frustrating...I hope someone can find the problem...

[griselda sirvent]

Hi

Anyone has any ideas on this ?

[Tsvetina]

Hi Griselda ,

I just answered the support ticket that you have submitted on the same issue. In case you have any further concerns, please post them there, so we can avoid duplicate posts.

For others who encounter such issue, I am attaching a small working sample using a grid quite similar to the one which is linked to in the previous post.

Greetings,
Tsvetina
the Telerik team