Running WDG_SQLDataSource reacted exactly as my WDG. SELECT filled the grid but unable to execute CUD stored procedures. Please attached screenshot.

Hello,

Can you describe further what you mean you are unable to execute CUD operations? Do you mean adding and deleting? In my sample when I change a value in a cell and then click save that change is then saved to the database file that was provided with the sample.

1. Mike P.,

2.  

3. Your code is clean and should perform CUD procedures. However, contrary to the CUD expectation, any interaction with the grid is muted. Except for the initial data load the grid is totally inactive. BTW,  I’m using VS 2013 for development.

4.  

5. This issue is now moot because many of the grid requirements are changed and I now need to do math calculations and extensive data editing.

6.  

7. My plan now is to build and perform all coding in code behind.

8.  

9. If you are familiar with grid code behind and can point me in the right direction it would be appreciated.

10.  

11. Thank you.

12.  

Hello,

Thank you for the update. I am attaching two samples. One demonstrates creating a grid in the code behind. The second demonstrates doing manual CURD operations and uses the server side events of the grid to update the datasource.

Thanks for your follow up. Most helpful.

I'm going to build a code behind framework over the next few days. I'll keep you updated.

Is this "Your 30-day free trial of ASP.NET priority support will end on 8/31/2017" applicable to your support?

I have extensive WinGrid experience and transitioning to WebDataGrid is thought-provoking.

Both WebGrid examples WDG_Code and WDG_BatchUpdating you provided seem fragmented and beyond displaying data in the grid CUD functionality is lacking.

Using VS 2013 and Infragistics 16.2 to step through the C# code there appears attempts to invoke CUD but there isn’t any interactive continuity. Just blocks of independent functions.

There is potentially workable code in both programs but I can’t put it together.  

Preferably, I would like to do row updating but I’d settle for batch updating. This should be a slam dunk solution even with extensive code behind editing.

In a few months [1/2018] I’ll be using igGrid but right now ASP.Net/WebDataGrid is in play.

If there any additional help you can provide it would be appreciated.

Thank you.

Hello,

Batch updating and row updating are not mutually exclusive. Batch updating is when all the changes you make (updating cell/row values, adding new rows, or deleting rows) are all kept on the client until a postback is triggered, typically by a save button. When batch updating is set to false provided the proper auto postback flags are set a postback will occur for each change made.

For row updating that is merely the mode in which updating values in the grid is performed. Other methods include cell updating, and a row edit template dialog.

When you saying the grid is lacking in CUD functionality what do you mean? The batch updating sample I sent you has row updating and row adding enabled you have to double click on the row or the AddNewRow to enter edit mode. I am attaching an updated able with row deleting enabled as well. The server side event which I believe you refer to as the “independent function” are there to update the datasource. When you connect to a DataTable or DataSet you are responsible for updating the datasource with the changes made and that particular datasource does not support AutoCRUD.

Cannot Create, Update, or  Delete from sample WebGrid.

software.snapcracklepop.net/WebGridError.png