.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Post Website and database online

Posted By:      Posted Date: August 27, 2010    Points: 0   Category :ASP.Net

I know this is a simple thing but i  don´t how to.....

I have the website working on my pc .... but i want to get it online with the database.

Do i have to put debug to false to publish it?

thanks in advance for your patience Smile

View Complete Post

More Related Resource Links

Toolbox: Database Documentation, API for Pre- and Post-Conditions, Blogs and More


In this month's column, Scott explores one-click database documentation, covers an API for pre- and post-conditions, takes a look at an interesting blog, and reviews the latest book about the ASP.NET MVC Framework.

Scott Mitchell

MSDN Magazine November 2009

Login database with visual studio 2010 asp website template


Has anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.

Single-page restore/recover in an online database

I am working with SQL Server 2008 64-bit (10.0.2531) on Windows Server Datacenter 2008 SP2 (64-bit). The problems I am having almost certainly stem from my lack of understanding of how SQL Server's transaction log is handled during recoveries. I am using this document as a rough guide. Here' what I am doing: 1. I intentionally corrupt a single data page in a normal table, so that I can practice single-page recovery. 2. I attempt to read the corrupt block in SQL. As expected I receive an error. 1> select top 10 firstname from ds2.dbo.customers 2> go Msg 824, Level 24, State 2, Server IP-0AF647E0, Line 1 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 4:896; actual 3:0). It occurred during a read of page (4:896) in database ID 5 at offset 0x00000000700000 in file 'C:\sql\dbfiles\cust1.ndf'. Additional messages in the SQL Server error log or system event log may provide more detail. 3. I take a log tail backup before I do anything to try to fix the corruption: 1> backup log ds2 to disk = 'c:\sqlbackup\ds2.bak' with norecovery 2> go Processed 5 pages for database 'ds2', file 'ds_log' on file 1. BACKUP LOG successfully processed 5 pages in 0.041 seconds (0.857 MB/sec). 4. I  restore the corrupt page from backup: 1> restore database ds2 page='4:896' 2> from disk='c:\sqlbackup\ds2.bak' 3> with norecovery 4&

Export data from local to online database

Hi MasterMinds, Here i want to export my data from local sql server 2000 DB to online sql server 2008 DB. waiting for your responses. 

How to send an email to a website and enter it into the database

Is there a way to send an email to a certain email address and have the message inserted into a database?  The subject would be intered into "Subject" table field and the message body would be inserted into the "Message" table field.Thanks.

database schema for online account opening form

what should be the database schema for online account opening form with joint account holders and every participants (in a joint account) have seperate contact and personal detials.Please suggest.

Can I have an SQL Express database open in VS2010E along with the website? "Login failed for user ..

Hi, as the topic says..Whenever I have my database open in Visual Studio 2010 Express, I get this error:Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.

How to use Post Relational Database like Intersystems or Matisse with ASP.NET

I have downloaded the softwares, .net bindings everything, i have my database, i need to create the same in Intersystems or Matisse and connect to my application.Also can we use Intersystems or Matisse or any other cache databases with windows applications?

Ajax enabled website and MSAcess Database

Hi i have problem while connecting to my MSAccess  Database in App_Data Folder in Ajax enabled website. How to bind Gridview with MsAcess Databse in Ajax enabled website???? Can u please help me , i m new to Ajax and Asp.net.   Thanks in Advance    

how to download Database in sql from Website Control panel ?


Dear Professionals.....

My control pannel doesn't has any option to download database so i want to download database from control panel. is there any way to download it ? any software,?

i'm a new user so please explained answer will be apperciated.



Website without any default membership Database. Is it possible?


I am in the initial stage of implementing a new webstie, which will use only twitter and facebook to login and use. So my approach is not use any Default memberhip database, just simple store the user data in my created "membership" database. I will set cookies and use sessions to restrict and grant access to various parts of the sites. So for example, the user creates an account and I set a cookie allowing him or her to traverse the site. And on each page request from the client browser check to see if my website cookie is there in the browser and if it has expired or not. Is this approach veasible? Thanks

sharing website(asp.net) mdf database on a network in multiuser environment


simple question:


I have create a web site in visual studio with form user authentication.  Thats create a mdf database in this path:



thats use Sql server


i would like to access this database with c# form application on a network with multi-user.

if i change the drive letter of the path above to f:\ (mapped drive) or \\server\c\, i got this message


System.Data.SqlClient.SqlException: The file "h:\Inetpub\wwwroot\website\App_Data\ASPNETDB.MDF" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file h:\Inetpub\wwwroot\website\App_Data\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.


i read that

Can't bring database back online after backup


Hey forummers,

I'm a little frustrated here. I have turned the default database offline then used windows explorer to copy the database to another location but when I tried to take the database online again this error came out:

Cannot open user default database. Login failed.
Login failed for user 'Zephere-pc\Zephere(JuLian Yong)'. (Microsoft SQL Server, Error: 4064)

The cause is that the default database is set offline, How do I bring it back online agian?

Website Database Design




I hope this post is in the right section.


I am designing a new application and I am after some advice in regards to designing the database structure. The application is being built in ASP.NET 3.5, SQL SERVER 2005 Express and using the built in membership/profiling tables.

The website will allow a user to login and verify their account with a link in an email they will be sent. I have got this working fine using the createUserWizard control, but I also need them to select the type of membership they want when creating an account and I am a bit stumped at what stage this should be put in.

Do I put this in when creating the user before they verify their account? or do I have it listed when they first login to allow them to change their membership status from a free account to a paying account?

They will have four options list below:

  • free
  • bronze
  • silver
  • gold

The bronze, silver and gold accounts will be a monthly subscription which the user can signup to.


The second part to this post is the main bit in how do I design my database for monthly subscriptions? I was thinking something along the lines below.


MembershipSubscription Table:

UserID, SubscriptionID, StartDate, EndDate

12345, 1, 10-10-201

Is a database online when it is changed from full to simple recovery model?



We have some databases that occaisally have very large ldf files and I have learned that the best way to shrink the ldf file is to change the backup mode to simple, shrink the log file, convert it back to full and do a full database backup so that the log file backups will run again. My question is during this process is the database available to the end users? When you guys do this do you feel it is nessesary to let the end users know or will they not notice what is going on?



Thanks! Kevin

Security tips reqd for website database

I need to provide access to a SQL Server 2008 database to a website for a client. I haven't done this before and I'm looking for tips on security.

The website will be hosted on a server either in a DMZ or external to the network. Access to the SQL server will be through a Cisco router.
The network is a workgroup, not a domain. The website needs write access to one database.

The client wants enough flexibility that I can't restrict them to using stored procedures. It'll be their responsibility to ensure they don't wreck their database.

I'll give them datawriter permissions on that database, and enforce a strict password policy.

What other things should I do to safeguard the SQL server from the evils of the internet?

Can't Connect to database after placing website in IIS


System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Unable to open the physical file "C:\DataBases\BankAccounts.mdf". Operating system error 32: "32(failed to retrieve text for this error. Reason: 15105)".
An attempt to attach an auto-named database for file C:\DataBases\BankAccounts.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend