用命令附加数据库

private void CreateDataBase(string strSql,string DataName,string strMdf,string strLdf)
  {
   String str;
   SqlConnection myConn = new SqlConnection (strSql);
   //EXEC sp_detach_db @dbname = 'BX_FreightMileage_2'//需要先将数据库分离出来
   str = "EXEC sp_attach_db @dbname = '"+ DataName +"', @filename1 = '"+ strMdf +"',@filename2='"+strLdf+"'";
   SqlCommand myCommand = new SqlCommand(str, myConn);
  
    myConn.Open();
    myCommand.ExecuteNonQuery();
    myConn.Close();
  
  }