Jump to content
Software FX Community

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


Recommended Posts

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...