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

Export To Excel Even With Special Character in Data

-
The Following C# code is used to Export data from ASP.NET to Excel with special characters try { Response.ContentType = "application/vnd.ms-excel 8.0"; Response.Charset = ""; Response.ContentEncoding = System.Text.Encoding.Default; this.EnableViewState = false; System.IO.StringWriter ObjWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter ObjHtmlTextWriter = new System.Web.UI.HtmlTextWriter(ObjWriter); rptUserDetails.RenderControl(ObjHtmlTextWriter); //dgdInitiative is the Grid name which is to be exported Response.Write(ObjWriter.ToString()); string strhtml = ObjHtmlTextWriter.ToString(); Response.AppendHeader("content-disposition", "attachment;filename=Users.xls"); Response.End(); } catch (System.Exception ex) { string strMsg = ex.Message; }
Read more

Get Plain Text from FCKEditor in any Browser.

-
The Following Function will help to get plain text from the FCKEditor in almost any browser. // below is the protyping for trim string. function trimString (str) { str = this != window? this : str; return str.replace(/^\s+/g, '').replace(/\s+$/g, ''); } String.prototype.trim = trimString; //following function will return plain text function GetPlainText(FCKEditorID) { var FEditor = FCKeditorAPI.GetInstance(FCKEditorID); var Result = ""; if (FEditor.EditorDocument.body.textContent || FEditor.EditorDocument.body.textContent=="" ) { //Firefox compitable browser Result = FEditor.EditorDocument.body.textContent.trim(); } else { //IE compitable browser Result = FEditor.EditorDocument.body.innerText.trim(); } return Result; }
Read more