Preparing A Database Driven Site Before Going Live?
May 18, 2010
I'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 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?
It's been so long since I've done this that I don't remember how.
Basically, I am creating a Web Application from scratch. I have dragged the LoginBox to the page and went to "Administer Website". Unfortunatel I see no where where I can choose to have the application talk to an externally-hosted database as opposed to defaulting to the "App_Data" folder. I am hosting an SQL instance named "SQLEPXRESS" on my development machine and have configured a database and user. I wish for the site to use this database and user and have set the connectionstring as follows in the web.config:
Yet even after adding that I see it showing no where in the "Administer Website" section. Please walk me through getting my application to talk to this database and configuring the necessary tables. I remember there needing to be some sort of exe I needed to run to do this, but my Google and forum searching is failing me.
I have a data driven site that displays a lot of information, particularly images, using listviews contained within UpdatePanels, since this data can change with each post back you often see 'submit query' before the Item image appears. So, is there a way of making the page display only after it has finished loading data? The delay as the page loads is only brief but looks quite ugly when 'Submit query' appears all over the site.
I will shortly be going live with a new .net web application. It will be deployed to a load balanced environment over 5 servers.Before go live there is a holding site on all the 5 servers to which the domain is currently pointing ->Prior to go live, I would like to deploy the new site to 5 servers and for the holding site to remain and for it to be what the public sees. And when the time comes, I can put the new site live with a flick of a switch. I also want the new site to be on the servers so that I can test it prior to go live.I am running in IIS7. This is common practice I presume so what is the easiest way doing that above and achieve installing the new site on the servers will not affecting the holding site. The new site be accessible to me but the holding site be viewed by the general public.
Is it OK to use css optimizers to before to make site live. When we can't to any other server side compression techniques (gzip, combining, sass, less etc)I want to make CSS file short and readable. How to use these tools without loosing css functionality. what options we should use and what not.
I am looking for a tutorial or more information on creating a Templating system to allow a user to edit the template of a ASP.Net website, Such as creating his or her own 'Skin'.point me in the right direction.
I amcreateinga dynamic web application and I wand the ablity to to control the bcakround color and backround images to controled by a database entery. does anyone know how to do this I am at a loss and I have been searching on the web all day to do this
I have a intranet site with Windows Authentication. I have 'Administrator' pages in an 'Administrator' folder that will only show for those in the admin group (windows security group) These pages work
I have a folder with sub folders containing reports. These permissions are broken down for each type of report. They have similar role priveleges. When I test the application, I can navigate to the pages. When I deploy the site live on the intranet the links don't return a page. Error missing link 404. Do I need to set something in IIS?
Thing is, if I run this locally and drop my internet connection the web service returns a 500 error (like I want it to do) and deleteCustomer(customer.id); is not called. However, on the live site if I drop my connection the web service does not return an error and deleteCustomer(customer.id); is called even if I don't have a connection to the internet (customer gets deleted from local database without being posted to the web server).
Did anybody do Database Driven - Horizontal and Vertical Nav without using XML?is it possible to bind menu control with query or view and pass query string to find particular horizontal nav and vertical nav?Please post working solution, i was trying for days to find a working solution. All the samples i tried is not working or it is too complex.i love to write and manage simple code.
UI markup to create the table shown below, which I have mocked up quickly to visualise what I need to do. The data is in the form of custom objects; a SelectedSession object which has a List (Of Students) sorted by AcademicYear, TeachingSet, then name.
So the question is how do I create that table from my custom object?
I want to include Microsoft AntiXss V1.5 library on my live site running in a medium trust setting.However, I got an error something like:Required permissions cannot be acquired.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Security.Policy.PolicyException: Required permissions cannot be acquired.I tried this in full trust setting on my development machine and everything works good.Looks like this will run only in full trust configuration.
when a user enters a bad email I am doing a check on this and throwing an exception message as follows, this works fine on the test site but for some reason the same code on the live site gives a "internal server error" (http code 500). The code below:
This is my third site that I use role management, but the first time this happens. I have two roles: Member and Admin. If Admin user login, Admin node on sitemap shows. It works very well on my local machine in Visual Studio Express 2008 and in Visual Studio Team 2008. But once I deploy files to live site, even admin login, the Admin node doesn't show. I have a Member management page from which I may see member's role, and I can see that user name is in the role Admin. What could be wrong?
I used ASP.Net Configuration manager to create roles, users, and access roles. Here is the code:
Over the years I have had a few of the websites I have developed submitted for penetration testing by clients. Most of the time the issues that are highlighted when the results return relate to the default behaviour of ASP .Net such as possible cross site scripting attacks etc.Are there any good articles on which vulnerabilities exist by default in an ASP .Net application and secondly are there any good checklists to follow which will help prepare a site in advance?