Exemple #1
0
        public void Killspid(string dbname)
        {
            SqlParameter param = new SqlParameter("@dbname", SqlDbType.VarChar, 255);

            param.Value = dbname;
            SqlHelp.ExecuteNonQueryForMaster("prc_Killspid", CommandType.StoredProcedure, param);
        }
Exemple #2
0
        public bool RestoreDataBase(string path)
        {
            SqlParameter param = new SqlParameter("@Path", SqlDbType.VarChar, 255);

            param.Value = path;
            try
            {
                SqlHelp.ExecuteNonQueryForMaster("restore database MyHouse from disk=@Path", CommandType.Text, param);
            }
            catch
            {
                return(false);
            }
            return(true);
        }