运行带的mdf文件示例的过程

1  下载别人的项目 提取数据库名称Test

2  建Console程序 创建Test数据库

        private void testc()
        {
            string link = @"Data Source=AA-158B22BD91A6\SQLEXPRESS;Initial Catalog=master;Integrated Security=True";
            SqlConnection Conn  = new SqlConnection(link);
            Conn.Open();
            string commandText = @"Create database Test";
            SqlCommand command = new SqlCommand(commandText,Conn);
            command.ExecuteNonQuery();
            Conn.Close();
        }

3  用下载的Test.MDF  替换本地磁盘上的 Test.MDF 

     C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA

 

4

cs  connectionstring

Data Source=AA-158B22BD91A6\SQLEXPRESS;Initial Catalog=master;Integrated Security=True

 

bs webconfig

<add name="TestString" connectionString="Data Source=AA-158B22BD91A6\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True" providerName="System.Data.SqlClient"/>
    

posted @ 2012-02-05 00:58  Ry5  阅读(280)  评论(0编辑  收藏  举报