I'm building a very simple ASP.NET MVC site that doesn't require a database and doesn't have user accounts or any other special ASP.NET stuff. When I first created the site with the ASP.NET MVC 1.0 site template in Visual Studio, the web.config page was configured to automatically connect to SQL Server Express as a User Instance.
Can I completely remove this dependency? If so, how do I get rid of all this database stuff?
I am using Reporting Services to render a report directly to PDF. It requires that I use two web references: ReportExecution2005.asmx and ReportService2005.asmx. The performance on web references seems really poor. Since my web server (IIS7) and my SQL Server (2008) are on the same box, is there a way I can reference them directly? If not is there any way I can explicitly cache them or something. First load is really really slow, second load is perfectly acceptable.
View 2 RepliesOn a website such as Amazon, they usually have a prodcut description which is normally 2 - 3 paragraphs of description. Would these information be stored on a database, or would they use include files for those sections, would it be stored in an XML file? I have a website which stores everything in a database and for most of it the website works. EG, in my database, I have a table with Column Names such as ISBN Number, Book Name, Publisher Name and all of which don't go above 50 characters! In some cases, the descriptions go on and on over several paragraphs. Where should this be stored? In the table or in another location which the database references?
View 3 RepliesLong ago, I created an ASPNET user for development use.However, every time I boot up my dev system, I'm presented with a user login for ASPNET, among others.I don't want to remove ASPNET; I need it for dev work.But how do I keep it from appearing among the list of User Logins available at boot-up?
View 4 RepliesMembership.DeleteUser not removing user from database
//Roles.RemoveUserFromRole("markwheeler1963@hotmail.com", "customer");
I am working at a site not orginally devleoped by me. The problem is that all the pages are working fine and have no problem at my local site. but the site is not showing any content at live site from database. Niether it shows an error for it. How can I find the problem?
View 7 RepliesI'm trying to include script and style references that will not break on deployment, however I can not even get the references to work locally. I have tried using Url.Content() and MVCContrib's <%=Html.ScriptInclude("")%>.
My scripts are in a Scripts folder on the root of the site; my styles are in the usual Content/css/ folder.
The scripts render like this:
<script type="text/javascript" src="/Scripts/MicrosoftAjax.debug.js" ></script>
This will not work in a view page in the Views folder. What am I doing wrong and what is the best way to handle this?
I would have thought Url.Content() would at least work for styles but used in my master page, the link rendered
<link href="/Content/css/Site.css rel="stylesheet" type="text/css" />
This does not work, because the Master Page is in a Shared folder, so what is really the way forward with this?
I have two columns first name and last name , that have duplicates, how can i remove the duplicates and only leave the distinct members intact?
View 6 Repliesi want to change news item along with photo gallery images on my asp.net page daily without using database is there any other way to do that other than using databse How can i do that
View 2 RepliesI have a very simple app on my local machine that uses the ASP.NET membership provider. This works fine on my local machine.I have published the app to our web server, and I need to know the specifics of setting up the application for asp.net membership to work.I have a basic understanding that it uses an MDF file and somehow connects to a SQL database (SQLEXPRESS I assume on my local machine) which holds the user/role information.
View 1 RepliesI have a small website that I am building using ASP.NET web pages Razor Syntax. It has an SQL CE 4 database in the App_Data folder. The connection and getting records from the database works fine in pages that are in the root directory and the /Account subdirectory. However when trying to get data from the database in pages that are in other subdirectories, connection to the database does not work. I get an error: Connection string "Database.sdf" was not found.It is using the connection string from the Web.config file in the root directory:
When I tried copying the root Web.config to the subdirectory I get the following error:The entry 'Database' has already been added. (C:UsersNameDocumentsVisual Studio 2010WebSitesSmallWebsitesubdirweb.config line 11).At the moment I'm stumped and can't seem to find an answer either in msdn or google.
Website (ASP.NET/C#) hosted at a dedicated hosting company (location 1) Company database (SQL Server) with records of relevant data (location 2). Location 1 & 2 connected through VPN. Customer visiting the website and wanting to pull data from the company database. No possibility of changing the server locations or layout (i.e. moving the website to an in-office server isn't possible).
What I want to do is figure out the best way to handle the data acces in this case, minimizing the need for time-expensive database calls over the VPN.
When a user enters the section of the website needing the DB data, you pull all the needed tables from the database into a in-memory dataset. All subsequent views/updates to the data is done on this dataset. When the user leaves (logout, session timeout, browser closed etc) the dataset gets sent to the SQL server.
If two web visitors are performing updates on the same data, the one finishing up last will have their changes overwriting the first ones. There's also no way of knowing you have the latest data (i.e. if a customer pulls som info on their projects and we update this info while they are viewing them, they won't see these changes PLUS the above overwriting issue will arise).
I think I already know the answer to this but I think you know more than me so best to ask :)I've got a basic .Net 3.5 site using C#, with no database backend.I've had a request for a function to be added to some forms for people to be able to save the forms and come back later to finish them off.Is this possible?I would think not without a database backend to save it too,
View 3 RepliesIs there a way to be able to create a new database when a company signs up to my site, and be able to use that database when he/she logs in, so for example if company A logs in he uses CompanyA database and if company B logs in he uses Company B database, now they all have the same table structure, just need to figure out a way to use a specific database depending on the user that logs in.
View 2 RepliesI've got a really good idea for a service I'd like to create for the web, but since I'm new to ASP.NET I'd like to get everything up and running before I go and buy hosting etc.
What I'm curious about is the database side of things.
I don't quite understand how I can create a datebase on my computer for the sake of testing and practicing (Presumably through mssql server) and then just transfer it to a hosting account when I'm ready.
I guess the main part I don't understand is how can I connect to a database on my computer via my application and then change the connection so that it points to the web version when I'm ready.
I know that when you create the database and include it in your project it's not technically inside your project (Right?), but it just seems that the application is very rigid once you've specified the connection.
I want to create small ecommerce site with sign up and log in pages. there are two categories jeans and T- shirt
I want to create category pages and product pages but I dont understand how to form tables in database means exactly how
many tables required for this application and how all tables are connected to each other ( how to make relationship in tables)
when particular user sign in and select particular pages how it will added in his cart.
I've built an online scheduling system for a local company so that they can have a calendar with the scheduled jobs for the day and so that the customers can check on the progress of the work being done for them. Allowing the customer to check for themselves would cut their phone call volume down to about 30% of what it is now leaving more time to complete jobs. Everything is fine but I'm concerned about instances when either the server has issues or the business' internet is down. I was considering making it a desktop application but then it wouldn't have the online abilities of allowing the customers to check on the job's progress.
So, basically, as it stands now, if there is problems with the internet connection, either at the business or at the host, the business loses their daily scheduler and if I make it a desktop app the customer has to call to check on the progress. Unless I can make the local database copy any transaction made on the desktop app to the database on the server. How would I go about doing something like that? Would this be a good reason to use a web service (something I've never done)?
I just set up user profiles using asp.net 3.5 using wvd. For each user I would like to store data that they will be updating every day. For example, every time they go for a run they will update time and distance. I intend to allow them to also look up their history of distance and time from any past date. My question is, what does the database schema usually look like for such a set up? Currently asp.net set up a db for me when I made user profiles. Do I just add an extra table for every user? Should there be one big table with all users data? How do I relate a user I'd to their specific data? Etc.
View 2 RepliesI want to have site.sitemap file that is build runtime from my sql database.
View 2 RepliesI have an SQL 2008 DB and I need to transfer the structure and the data to an off site, off network database. I need to somehow create a physical file that represents the structure and data within the db that can be loaded in another instance of SQL Server 2008.
View 1 RepliesI´m about to program a common application/website scenario. It contains pages which are presented to users, and some business logic behind, with a database connection class.
My questions are:
Q1: Should the database class be singleton? If so, why? Because does it even matter when every single user is in their own process on the server, and therefore each user has their "own" singleton database instance?
Q2: How would you normally direct users around the site? Would the Default.aspx page create instances of the required classes? And when the user is directed to a new page, how would you normally refer to these instances?
Q3: What kind of general information do you save in the Session variable? Is it a big no-no to save class instances?
How to develop side with 20 different local language in india using sql database. the content are coming from database only. and when i select the language from dropdown it should convert this database text to appropriate language.
View 1 Replieshow to connect database create in sql server ,to my web site upload on domain.
View 1 RepliesThis will be my first time trying to upload a ASP.NET site. I would like to upload my site by simply using ftp and transferring the contents of the project directory so that the site will be easy for me to make future updates. Where can I find directions for uploading a ASP.NET site via ftp? I am assuming that I will need to edit the connection string in the web.config file. However, my hosting company told me to just make a full backup of of the database into .BAK file format and upload it via FTP to your the "private" folder. Anyone have any experience with something like this and can tell me how this would affect the connection string? Can I back up the database to a .BAK file from within Visual Studio 2008 or do I have to use Management Studio? I am using Visual Studio 2008 with ASP.NET 3.5, C#, and SQL Server 2008 Express Edition.
View 1 RepliesI try to create a wordpress site from the gallery and I get an error that says that it cannot find database. I dont have mySQL installed. I thought that WebMatrix would download and install it. Does WebMatrix Beta 3 expect MySQL to be installed? And if so, which version?
View 1 Replies