Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by K_Drive

  1. I am trying to complete what seems like a very simple example project on MSDN to learn how to use Profile Properties that are set up in the web.config file for an ASP.Net/C# project. Here is the link to the MSDN page:MSDN Profile Properties walkthrough I followed the C# steps on this page for the first simple project up to "To test the PostalCode property". I am getting the error below when I run/debug. I am using Visual Studio. I also have SQL Server. I copied/pasted the code. I am getting a server error listed at the end of this post. If I am reading the MS web page correctly, the first simple example uses the anonymousIdentification element. So, no login is necessary I set up this simple project in a new page within an existing project that has a database. I can see the Profile table in SQL Server. But, the app just can't seem to get to it. Is there something else I need to get profiles to work involving the database? -- error listing: -- System.Web.HttpException was unhandled by user codeMessage="Unable to connect to SQL Server database."Source="System.Web" ErrorCode=-2147467259 StackTrace: at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) at System.Configuration.SettingsBase.get_Item(String propertyName) at System.Web.Profile.ProfileBase.GetInternal(String propertyName) at System.Web.Profile.ProfileBase.get_Item(String propertyName) at System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) at ProfileCommon.get_PostalCode() in c:\Users\amredstart\AppData\Local\Temp\Temporary ASP.NET Files\website1\839131dc\b553a82a\App_Code.ocx-hpma.0.cs:line 21 at _Default.Page_Load(Object sender, EventArgs e) in c:\Users\amredstart\Documents\Visual Studio 2005\Projects\WebSite1\CustomerProfiles.aspx.cs:line 16 at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  2. Thank you for the replies and for the MSDN reference. I will read more. K
  3. I am going through a book on C# and ASP.Net.I ran across a statement that I don't quite understand.The book does not explain it.From the context I am assuming that it is an "if" statement. Here it is: shippingRegion = (profile.ShippingRegion == null || profile.ShippingRegion == "" ? "1" : profile.ShippingRegion); Here is the code around it: ProfileCommon profile = HttpContext.Current.Profile as ProfileCommon; address1 = profile.Address1; address2 = profile.Address2; city = profile.City; region = profile.Region; postalCode = profile.PostalCode; country = profile.Country;> shippingRegion = (profile.ShippingRegion == null || profile.ShippingRegion == "" ? "1" : profile.ShippingRegion); dayPhone = profile.DayPhone; evePhone = profile.EvePhone; mobPhone = profile.MobPhone; email = Membership.GetUser(profile.UserName).Email; If I need to add more explanation or code, please let me know. Thanks. K
  4. Yes! PasteBin! Thank you, boen robot! niche: I will look more closely at jsfiddle. It looked interesting. K.
  5. I seem to remember a website out there that allowed you to post a block of programming code. After you saved it you were given a link to give to others so they could get to your posted code. You didn't have to have an account or login, which meant the only way to find your post(s) were to keep the link(s). Does this sound familiar to anyone? K
  6. K_Drive

    Book suggestion

    Thanks, jonmunm.I will look into these.(This is a CSS question, I thought.): )
  7. K_Drive

    Book suggestion

    I was wondering if anyone had a good web design book to replace the O'Reilly book: "Web Design in a Nutshell" which was published in 2006.I really like this book and I think I learned a lot from it when I was trying to learn CSS and page design. But, parts of it are out-of-date. I don't like to recommend to to people who want to learn CSS now. Any suggestions?I think the "Sams Teach Yourself HTML and CSS in 24 Hours" isn't too bad. But, the O'Reilly book covered a lot more topics.
  8. I am running SQL Server 2005 on my laptop from a recent ASP.Net project. The web app that I worked on used the FullText search feature.I am now using the same SQL Server 2005 (and VS 2005) to go through an ASP.Net E-Commerce textbook.I am trying to create a FullText Catalog for a new database for the book's exercises.I get this error message when I try to run this command: Create FullText Catalog BalloonShopFullTextError message:Msg 7689, Level 16, State 1, Line 1Execution of a full-text operation failed. 'No such interface supported' I can see the SQL Server FullText Search running in my Task Manager's Services window. And, I have the checkbox checked in this project's database's Propterties window/Files tab.(I ran the " sp_fulltext_database 'enable' " command successfully, too.)What am I missing? I know that the FullText option was used in the previous project I worked on with this copy of SQL Server. Why isn't it working for this new database? What can I do to get it working for this new database?I think my only option is to backup my database files and uninstall/reinstall SQL Server.
  • Create New...