Exemple #1
0
        public frmDatabase(Server server)
        {
            // Information that is used to connect to the MySql Database
            string dbhost = "localhost";
            string dbuser = "******";
            string dbpass = "******";
            string dbdatabase = "dataman";

            // The server connection that is used to connect to the database.
            this.server = server;

            // Creates all the controls for the form.
            InitializeComponent();

            // Checks to make sure the connection to the server is still active and then
            // attempts to connect to the database.
            if (server.isJschConnected())
            {
                this.statLbl1.Text = "Connected To Server";
                server.setPortForwarding("131-server.ecs.csus.edu");
                mySqlConn = new SqlDatabase(dbhost, dbuser, dbpass, dbdatabase);

                data = new DataTable();
                data = mySqlConn.queryDatabase("show tables;");
                fillDataGrid(data);
            }
        }
Exemple #2
0
        public frmController(Server server)
        {
            // Information that is used to connect to the MySql Database
            string dbhost = "localhost";
            string dbuser = "******";
            string dbpass = "******";
            string dbdatabase = "dataman";

            // The server connection that is used to connect to the database.
            this.server = server;

            // Creates all the controls for the form.
            InitializeComponent();

            // Checks to make sure the connection to the server is still active and then
            // attempts to connect to the database.
            if (server.isJschConnected())
            {
                this.statLbl1.Text = "Connected To Server";
                server.setPortForwarding("131-server.ecs.csus.edu");

                mySqlConn = new SqlDatabase(dbhost, dbuser, dbpass, dbdatabase);

                // Will return the result of trying to connect to the database. Will have
                // a null string if it was able to connect.
                string result = mySqlConn.connectDatabase();

                if (result == null)
                {
                    if ( rdoDatabase.Checked )
                    {
                        loadDatabaseAccounts();
                    }
                    else if ( rdoProject.Checked )
                    {
                        loadProjectAccounts();
                    }
                }
                else
                {
                    MessageBox.Show(result, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    Application.Exit();
                }
                // Defaults the combo box to unsynced.
                this.cmboAcctStatus.SelectedIndex = 0;
            }
        }
Exemple #3
0
        public frmDatabase(Server server)
        {
            // Information that is used to connect to the MySql Database

            string dbhost = "131-server.ecs.csus.edu";
            string dbuser = "******";
            string dbpass = "******";
            string dbdatabase = "dataman";

            // The server connection that is used to connect to the database.
            this.server = server;

            // Creates all the controls for the form.
            InitializeComponent();

            // Checks to make sure the connection to the server is still active and then
            // attempts to connect to the database.
            if (server.isJschConnected())
            {
                this.statLbl1.Text = "Connected To Server";
                server.setPortForwarding(dbhost);
                mySqlConn = new SqlDatabase(dbhost, dbuser, dbpass, dbdatabase);

                // Will return the result of trying to connect to the database. Will have
                // a null string if it was able to connect.
                string result = mySqlConn.connectDatabase();

                if (result == null)
                {
                    data = new DataTable();
                    data = mySqlConn.queryDatabase("show tables;");
                    fillDataGrid(data);
                }
                else
                {
                    MessageBox.Show(result, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    Application.Exit();
                }
            }
        }