[Solved] Hierarchical / Programmatic Binding / Insert-Update-Delete

[Andrew M]

I'd be very grateful for some feedback to my problem.

I've taken the Web UI example in this link
http://www.telerik.com/community/code-library/aspnet-ajax/grid/automatic-operations-in-hierarchical-grid-with-sqldatasource-control.aspx
and added a RadUpload to level 2 to allow users to upload docs to the database.

The Insert and Delete commands work fine. However, if I select an existing record to edit, I get an error. The error is due to the fact that RadUplad doesn't have a file since I didn't select a file. I want to keep what the user uploaded previously. If I do select a file, it works.

The above example uses the declarative method of binding to sqldatasource. How do i go about doing the binding manually for level 2 so that I can trap if a file has or has not been uploaded and hence update or not update the doc to the database.

Thanks

[Andrew M]

A quick updated.

 

I saw an article about stored procedures so moving the logic of checking if a file is uploaded or not to the sp.

 

So far so good.