DataGrid doesn't keep data between page loads

[iambrunner]

Hi all,

I'm pretty new to ASP.Net. I have a datagrid that is bound to some data at runtime on the first page load. EnableViewState is set to true for the datagrid. My problem is that the data in the datagrid disappears between page loads. If I repopulate the datagrid on each page load, I won't be able to retrieve the textbox values to update the DB, AFAIK.

The code is here:

http://pastebin.ca/7854

Any help would be much appreciated. Thank you in advance.

 

[Kalisto]

What happens if you step through your code in the debugger?

Try putting a break in the init function, then refresh the page. Look at the state of the datagrids data at the top, adn watch to see where it gets overwritten...

Why are you creating an SQL connection and opening it outside the if !(IsPostBack), this is (albeit a minor one) waste of time, as if the page is on a postback, you open a connection for nothing..