C#

damianrda wrote:

Im trying to develop an app which is kind of like a smaller custom 'taskbar' i cant seem to find a way to shrink down the desktop area, essentially reserving 32 pixels from the top of the screen so maximized apps do not hide it/app does not hide app titlebar

I are Troll

private void RunAllScripts()
        {
            //Create a list of scripts
            List<string> scripts = new List<string>();
            scripts.Add(@"D:\Scripts\Script1.sql");
            scripts.Add(@"D:\Scripts\Script2.sql");
            scripts.Add(@"D:\Scripts\Script3.sql");

            //Open a connection
            Server server = null;
            SqlConnection conn = null;
            try
            {
                conn = new SqlConnection(sqlConnectionString);

                server = new Server(new ServerConnection(conn));

                foreach (string scriptFile in scripts)
                {
                    RunScript(scriptFile, server);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error " + ex.Message);
            }
            finally
            {
                if (conn != null)
                    conn.Close();
            }
        }

        private bool RunScript(string path, Server server)
        {
            string script = String.Empty;

            if (!File.Exists(path))
                return false;

            try
            {
                using (StreamReader sr = new StreamReader(path))
                {
                    script = sr.ReadToEnd();
                }
            }
            catch (Exception ex)
            {
                string msg = String.Format("The script {0} not found. {1}", path, ex.Message);
                MessageBox.Show(msg);
            }

            try
            {
                //Run the script
                server.ConnectionContext.ExecuteNonQuery(script);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error " + ex.Message);
                return false;
            }
            return true;
        }