Lesson 4: Understanding Web Application State

i recieve the following error when using C# to follow this tutorial.

App_Code.cy2wsazk.0.cs

// <auto-generated>

//     This code was generated by a tool.

//     Runtime Version:2.0.50727.1433

//

//     Changes to this file may cause incorrect behavior and will be lost if

//     the code is regenerated.

// </auto-generated>

...

   public virtual string MyNewProperty {

       get {

           return ((string)(this.GetPropertyValue("MyNewProperty")));

       }

       set {

           ****this.SetPropertyValue("MyNewProperty", value);**** Unable to connect to SQL Server database.

       }

   }

I do not understand.   I started a new webpage and followed the directions explicitly.  i do not understand why i am getting this error.

"Unable to connect to SQL Server Database" Check to confirm that the sql service is runnig, also confirm that u specified the correct database name in ur connection string

Please how were u able to download this video??????????????

when i click the download link it does not respond

I am following along with the VB version and am doing exaclty what is being done in the video. When I get to about 26 minutes we add the following lines to the web.config file:

<anonymousIdentification enabled="true"/>

<profile enabled="true">

    <properties>

<add name="MyNewProperty" allowAnonymous="true"/>

    </properties>

</profile>

When I added this code and ran the project, I get an error saying it cannot find the SQL Server. Up to this point the project has been running fine. And no use of a SQL server has been used.

Any Help?

Lee Armitage

Hi,

Check out this link: weblogs.asp.net/.../423703.aspx

And this links about Profile Providers: msdn2.microsoft.com/.../014bec1k.aspx

msdn2.microsoft.com/.../cc163457.aspx

nice to me i try to see

finally a full screen option online. so no download :D

Can be pretty slow in rushing all page objects.

useful video but i felt that I’m lost coz of the too many objects are being used :(

I followed the links... and when i got to Step 3, i got confused... does anyone know where you open this?

got it now!

So which one is better to use for websites with higher traffic?

Hi Arash,

As I understand it after watching the video, if a web site experiences heavy traffic, using Viewstate consumes bandwidth whearas using the session object consumes server memory. The alternative is to create a profile object in the web.config file which stores the information in a database, xml-file or wherever you designate.

If anyone gets an "Unable to connect to SQL Server Database" problem when referencing the profile object, then it could be because they did what I did. I deselected installing the "SQL Server Enterprise Edition (or whatever it's called) when installing Visual Web Developer. (I did so because I already had SQL Server installed on my machine.) I went to the download site and installed it. At first it didn't work, but later on (I guess after a restart of VWD) I no longer have this problem.

... actually I do still get an SQL error, but this seems to be due to a time out.

If i run the application a second time, so things load faster, then it works ok.

At 31:46 in the video, the Label does not populate with the value from the URL string when he runs the page application.  I sat here trying to figure it out myself having paused the video before I realized it did not work for the guy in the video either.

How come the guy just moves on to the next topic even though the code obviously didn't work when he ran the page without trying to fix it or explain why it didn't work for him either?

Nevermind.  I see that he re-traces the steps and see why it wasn't working.  Would have been nice to edit that one part out to avoid confusion LOL...  Great videos though overall.  I am learning a lot more from these than other resources online.

Got to say I am extremely happy with the videos and the fact this is a free application is a great bonus. I think the presenter of the vids is good for my style of learning and after running through only up to lesson 4 feel really comfortable with it all. V well done and thanks MS ( for a change lol ).

Good lesson - I am enjoying all this series

thanks a lot

Its a good tutorial thanks....

good article thank you

i want to create a form and insert a data in database

and read it in next page pls help me?

Hi ,

   Nice video.

Awesome...

Hi,

I followed the tutorial but I also get the "Unable to connect to SQL database" error.

I tried to follow the links romulusc has posted but they didn't help?

Anyone?

I too get the SQL error using VSExpress 2008

As someone has already states, I'm sure it's because I also didn't install the SQL server express as we use SQL Server 2000 at work.

Is there some setting where I can force ASP.net to look to another server to store it's data?

Hi

At 12:45 it's stated that the encoded string held in the viewstate hidden field "helps us retain the state of the text boxes". This seems wrong, in that, why would ASP need to store anything in the page simply to echo the state of the form back the browser?

Between about 25:30 and 27:35 various techniques for maintaining state are summarised. The Application object is discussed as holding stuff for every page and every user. But it is implied that this is not the case for the Profile object.

Surely this is incorrect? (Having tried the code supplied here, I had different browser sessions accessing & updating the same Profile variable, which would suggest it's global to everything).

Has this not confused anyone else??? Or am I being dumb?

Thanks !

Thank you very much. I like it.