I have a web part that I am trying to use within Sharepoint 2007. The web part has two drop down menus that are used to execute a SQL stored procedure. When the stored procedure is executed it creates a table with the rows being dynamically determined by the stored procedure results. I also have a button within the web part that adds a new row to the table, this causes a post back and a new row is added. The problem comes when the post back occurs as the code to dynamically create the table is called again and any information the user has changed on the page reverts back to the data from the stored procedure.
Is it possible to have data in a table edited and then keep that same information when a post back occurs?