ASP.NET

Server Error in '/' Application.

Database 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\LoginDB1.mdf' already exists. Choose a different database name.
Cannot attach the file 'C:\Users\Atta\Documents\Visual Studio 2012\WebSites\WebSite3\App_Data\aspnet-WebSite3-20170707151050.mdf' as database 'LoginDB1'.

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.Data.SqlClient.SqlException: Database 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\LoginDB1.mdf' already exists. Choose a different database name.
Cannot attach the file 'C:\Users\Atta\Documents\Visual Studio 2012\WebSites\WebSite3\App_Data\aspnet-WebSite3-20170707151050.mdf' as database 'LoginDB1'.

Source Error: 


Line 20:     {
Line 21:         SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connect"].ToString());
Line 22:         con.Open();
Line 23:         string query = "select count(*) from userlogin where username ='" + txtBox1.Text + "'and pass '" + txtBox2.Text + "'";
Line 24:         SqlCommand cmd = new SqlCommand(query, con);

Source File: c:\Users\Atta\Documents\Visual Studio 2012\WebSites\WebSite3\Default2.aspx.cs    Line: 22 

Stack Trace: 


[SqlException (0x80131904): Database 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\LoginDB1.mdf' already exists. Choose a different database name.
Cannot attach the file 'C:\Users\Atta\Documents\Visual Studio 2012\WebSites\WebSite3\App_Data\aspnet-WebSite3-20170707151050.mdf' as database 'LoginDB1'.]
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling) +821
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +332
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +38
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +699
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) +89
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +426
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +78
   System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +191
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +154
   System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +21
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +90
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +217
   System.Data.SqlClient.SqlConnection.Open() +96
   Default2.Button1_Click(Object sender, EventArgs e) in c:\Users\Atta\Documents\Visual Studio 2012\WebSites\WebSite3\Default2.aspx.cs:22
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9819334
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +204
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +12
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +15
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1639

Member 12761341 wrote:

Database 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\LoginDB1.mdf' already exists. Choose a different database name.

Member 12761341 wrote:

string query = "select count(*) from userlogin where username ='" + txtBox1.Text + "'and pass '" + txtBox2.Text + "'";

using System; 
using System.IO; 
using System.Web; 
using System.Web.Caching; 
using System.Web.Hosting;

public class Fingerprint 
{ 
    public static string Tag(string rootRelativePath) 
    { 
        if (string.IsNullOrWhiteSpace(rootRelativePath)) return string.Empty;
        
        if (rootRelativePath[0] != '~')
        {
            rootRelativePath = "~" + rootRelativePath;
        }
        
        string result = HttpRuntime.Cache[rootRelativePath] as string;
        if (result == null) 
        {
            string absolute = HostingEnvironment.MapPath(rootRelativePath);
            DateTime date = File.GetLastWriteTime(absolute); 
            result = rootRelativePath + "?v=" + date.Ticks;
            HttpRuntime.Cache.Insert(rootRelativePath, result, new CacheDependency(absolute)); 
        }
        
        return result; 
    } 
}

<link rel="stylesheet" href="@Fingerprint.Tag("~/content/file.css")" />