public bool AttachDB_Script(string ServerName,

            string mdfPhysicalPath, string OtherConnectionStr)

        {

            SqlConnectionStringBuilder sqlConBuild = new SqlConnectionStringBuilder(

                    "Data Source=" + ServerName + ";"

                    + "Initial Catalog=" + Objects.ModuleBO._DBMaster + ";"

                    + OtherConnectionStr);



            SqlCommand sql_Cmd = new SqlConnection(sqlConBuild.ConnectionString).Create  Command();

            sql_Cmd.CommandType = CommandType.Text;

            sql_Cmd.CommandText =

                string.Format("CREATE DATABASE [{0}] ON " +

                @"( FILENAME = '{1}' )FOR ATTACH go ",

                Objects.ModuleBO._DBName, mdfPhysicalPath);



            bool attached = true;

            try { sql_Cmd.Connection.Open(); sql_Cmd.ExecuteNonQuery(); }

            catch (Exception e) { attached = false; throw e; }

            finally

            {

                sql_Cmd.Connection.Close();

                sql_Cmd.Connection.Dispose();

                if (attached)

                {

                    sqlConBuild.InitialCatalog = Objects.ModuleBO._DBName;



                    BaseDefinetionDAL.Sql = new SqlService(sqlConBuild.ConnectionString);

                    // -------------------------------------------------------------

                    Properties.Settings.Default.ConnectionString = sqlConBuild.ConnectionString;

                    WriteConnectionStringToXML(sqlConBuild.ConnectionS  tring);

                }

            }

            return attached;

        }