tags:

views:

34

answers:

1
Q: 

WebPartManager issue in ASP.Net

Hello everyone,

I am using ASP.Net + .Net 3.5 + VSTS 2008 + IIS 7.0 + C# to develop a web application. I am using WebPartManager, and I find when personlization feature is enabled to true, the web application will connect to SQL Server Express version database automatically.

BTW: I find this by when stop SQL Server Express version service instance, there will be database connection error shown.

My question is, (1) why WebPartManager needs to connect to SQL Server Express version when personlization feature is enabled (in other words, SQL Server Express version is used by personlization feature for what purpose)? (2) If I need personlization feature, any solutions to chnage to SQL Server Enterprise other than SQL Server Express version?

thanks in advance, George

+1  A: 

The data is stored in a .mdf file in your /Data folder.

You can change to a SQL Server store using the web adminstration tool or SQL Server set up wizard.

If you need to use another source other than SQL Server, you need to write your own Provider to do so.

TheGeekYouNeed  2010-07-10 16:43:00
Thanks, I think you mean by default -- "data is stored in a .mdf file in your /Data folder"? I am interested in this point, do you have any recommended readings for this point? Thank you!
George2  2010-07-10 16:48:30
http://msdn.microsoft.com/en-us/magazine/cc163965.aspxhttp://msdn.microsoft.com/en-us/magazine/cc300767.aspx#S8 Google? :)
TheGeekYouNeed  2010-07-10 19:19:31
Thanks, question answered!
George2  2010-07-11 07:22:30

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?