Insert, Update, Delete on grid FX and SQL Data Base

[oamelunge]

How do I Insert Update an delete form grid FX to SQL Data Base??

How do i perform de event SelectedItemChange, the example you provide DataBind_UboundData does not work for update or delete?

 

Could you providme an example?

[AngelR]

To insert, delete and update into a SQL server table, you need to set Advanced SQL Generation Options when you are configuring the SQLDatasource to bind the grid.

1. Open the Configure Data Source Wizard to create a new Datasource to your SQL Server Database. (To see more on this topic you can read the Data Connectivity section and/or How Do I section on the Grid FX programmers guide)

2. Select the table and columns to be used on the grid.

3. Click on the advanced button. The Advanced SQL Generation Options dialogue appears.

4. Check the Generate INSERT, UPDATE, and DELETE statements option. Then click Ok.

5. Finish the Data Source Wizard.

You can confirm the grid is in editing mode going over the Editing properties in the Data group. Deleting, Inserting and Updating enabled property should be true.

To test, click on an item on the grid and trigger the floating bar; you