DataGrid Lost

[BiniamTek]

I have just upgraded my system from VS .NET 2002 to 2003. When I run my Web App that reads and displays data into a DataGrid from a SQL server, the DataGrid is no longer there.

I had deployed my 2002 file and even the

http://localhost/xyz

is not longer displaying the DataGrid.

Did the upgrade mess up with IIS?

Please help.

Thanks.

 

[jfrost10]

Do you mean that your datagrid is no longer visible in the designer, or just doesn't appear when rendering in the browser?

D

 

[BiniamTek]

It is visible in designer but lost at run time (in Browser). I believe that the Database is not accessed and I do not know why or how to fix it.

 

[jfrost10]

Have you stepped through the code to make sure that you're getting the data properly?

D

 

[ksbrace]

Did you see if .NET IDE removed your Me.SqlConnection.ConnectionString = "YOUR CONNECTION STRiNG"
under the #Region " Web Form Designer Generated Code " preprocessor directive? It is continually removing mine everytime I click on the datagrid or datalist, which causes my datagrid not to appear at runtime.

 

[jfrost10]

Just an aside:

you probably shouldn't be storing the connection string there anyway. Typically, they're best stored in:
- web.config
- encapsulated in a class
- available as a constant declared in a module

If you place it in the web form designer code region, not only can freaky stuff like what you described happen, but you can only access it from that page, meaning you'd have to re-declare it for each aspx page you have.

hth

D'Arcy

 

[ksbrace]

I agree and mine is stored in the web.config
I am using it as:

Me.SqlConnection.ConnectionString = Application("gLeedsDataSource")

, but the IDE keeps removing it.

 

[BiniamTek]

ksbrace

I think what you need is a service pack from microsoft.com for datagrid/data loss.

Mine is also in Web.config and it is not removed.

I just solved my problem by redoing the whole project again with copy/paste of all my WebForms.