vb.NET - Datalist, Editing, Updating & Paging

MargeS

I can successfully create a databound DataList.
I can successfully create an Edit version of it and update the database through the DataList.
I can also successfully page the results.

But I can't combine the paging and the editing/updating.
The _EditCommand toggles to edit mode.
The _CancelCommand toggles back to read mode.
The _DeleteCommand deletes the row using the id as the identifier (Dim id As Integer = Convert.ToInt32(AllPendingImages.DataKeys(e.Item.ItemIndex)))

But the _UpdateCommand doesn't fire. The updateCommand works when the paging code is not added to the script.
I rebind the data after each command and after I move forward/backward in the dataset.

There is something I am missing, and I can't figure it out!! Any help appreciated!

Evil Phil

Post your code.

MargeS

I have uploaded the aspx and aspx.vb files.

The datalist displays all the info about an uploaded image and info about the user who uploaded the image. The aim of the page is to accept or decline the image for publishing. (1= decline, 2= accept) using the imageId as the indentifier.

Currently it all works until I go to edit mode.
When I debug it seems to be setting the DataKey id to _Page so the wrong value is being passed to the stored procedures in
Sub AllPendingImages_DeleteCommand and Sub AllPendingImages_UpdateCommand. These aren't firing. Actually the _Delete is firing after I hit the delete button a second time.

I've been going around in circles with Page.IsPostBack because I think this is where the problem is. But I've been looking at it for so long now, I don't know any more!

MargeS

I've partly worked this out....

I put If Page.IsPostBack Then around my DeleteCommand code. So this sub works.

But going into edit mode for the UpdateCommand seems to change the value of id so I haven't got that part working yet.

MargeS

I finally got this to work. Yippee!
I decided to try and get the same result by doing it a different way and in the process I figured out how to do it the first way. So now I can do it 2 different ways. If ya follow??

There is alot to be said for persistance!