Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

How to save data from Grid Control in a webform back to SQL Database

Created: 02 Mar 2011 | 1 comment
Jayanta Roy's picture

We are able to display the data in a grid through web form but unable to save the data. When a user edits the data on grid we would like to capture that data and update it to sql database. Basically on button click event we want to save the data through a sql generator component(which has update statement taking input parameters) written in a  library but in button click event handler code we can't see any grid control data which we would like to pass to our sql component. Any help will be greatly appriciated.

 

Regards,
Jayanta

Comments 1 CommentJump to latest comment

dfnkt_'s picture

When dealing with an editable grid a postback must occur to update the 'thisform.data' information. A postback occurs after the user clicks out of the grid, the page will flash. I have just used a button component that links to a Write To Table component generated by the SQL Table generator. It's all about datatypes and objects being correct.