Using Session State with SQL Server

-
SQL Server Session State in ASP.NET 2.0
The Following Command is used to install Sql Server Session state for ASP.NET 2.0
c:\Program Files\Microsoft Visual Studio 8\VC>aspnet_regsql.exe -C "Data Source=PC8\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True" -ssadd -sstype c
Start adding session state.
..........
Finished.
To use this custom session state database in your web application, please specify it in the configuration file by using the 'allowCustomSqlDatabase' and 'sqlConnectionString' attributes in the \ section.
c:\Program Files\Microsoft Visual Studio 8\VC>
The Following statement is needed to add in WEb.config File

< system.web >
< sessionstate allowcustomsqldatabase="true" timeout="20" mode="SQLServer" cookieless="false" sqlconnectionstring="Data Source=PC8\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True" > < /sessionstate >
< /SYSTEM.WEB >

Comments

Yograj said…
Hi Sir,

This Link is very good, where i can see new feachers in VS2010.

Thanks a lot sir.

Best Regards
Yograj Pandey
January 21, 2011 at 6:40 PM
Post a Comment

Popular posts from this blog

To Move items from one ListBox to another Listbox

-
Image
To Develop a page with the following type of requirement I had used the server side methods for this of asp.net and use updatepanel from ajaxtoolkit to avoid postback to the page. The aspx file code:- <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <table> <tr> <td style="width: 100px; height: 104px"> <asp:ListBox ID="lstReturnFields" runat="server" DataTextField="name" DataValueField="start" Rows="6" SelectionMode="Multiple" Width="150px"> </asp:ListBox> </td> <td align="center" style="height: 104px" valign="middle"> <asp:I
Read more

Receive Json Web response in C#

-
Following code use to get Json Response in My object using (var twitpicResponse = (HttpWebResponse)request.GetResponse()) {         using (var reader = new StreamReader(twitpicResponse.GetResponseStream())) {             JavaScriptSerializer js = new JavaScriptSerializer();             var objText = reader.ReadToEnd();             MyObject myojb = (MyObject)js.Deserialize(objText,typeof(MyObject));         }     }
Read more