Database.Mdf Faild。存在相同名称的数据库，或者指定的文件无法打开或位于Unc Sh​​are。我所做的？ [英] Database.Mdf Faild.A Database With The Same Name Exists,Or Specified File Cannot Be Opened Or It Is Located On Unc Share. What I Do?

问题描述

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public class admin
{
    SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\admin_app\App_Data\Database.mdf;Integrated Security=True;User Instance=True");
    public admin()
    {
        con.Close();
        con.Open();
    }
	
    public void ExecuteCommands(string str)
    {
        SqlCommand cmd = new SqlCommand(str, con);
        cmd.ExecuteNonQuery();
    }
    public DataTable GetDataTable(string str)
    {
        SqlDataAdapter sda = new SqlDataAdapter(str, con);
        DataTable dt = new DataTable();
        sda.Fill(dt);
        return (dt);
    }
    public DataSet GetDataSet(string str)
    {
        SqlDataAdapter sda = new SqlDataAdapter();
        DataSet ds = new DataSet();
        sda.Fill(ds);
        return (ds);
    }
    public void FillGrid(GridView gd, string str)
    {
        DataTable dt = GetDataTable(str);
        gd.DataSource = dt;
        gd.DataBind();
    }
    public void FillDataList(DataList dl, string str)
    {
        DataTable dt = GetDataTable(str);
        dl.DataSource = dt;
        dl.DataBind();
    }
    public void FillForm(FormView fv, string str)
    {
        DataTable dt = GetDataTable(str);
        fv.DataSource = dt;
        fv.DataBind();
    }
}

推荐答案

而不是放置物理路径尝试提供应用程序路径。

试试这个 -

Instead of placing a physical path try to give application path.
Try this-

string DBPath=Server.MapPath("App_Data\Database.mdf");
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename="+ DBPath +";Integrated Security=True;User Instance=True");

希望，它有帮助：）

Hope, it helps :)

这篇关于Database.Mdf Faild。存在相同名称的数据库，或者指定的文件无法打开或位于Unc Sh​​are。我所做的？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！