Пример #1
0
 private void testDatabaseToolStripMenuItem_Click(object sender, EventArgs e)
 {
     try
     {
         MySQLFunction mySQLFunction1 = new MySQLFunction();
         if (mySQLFunction1.connect())
         {
             setStatus("Database connection succeed", Color.Green, 100);
             MessageBox.Show("Database connection succeed");
         }
         else
         {
             setStatus("Database connection failed, Please make sure your config are right", Color.Red, 0);
             MessageBox.Show("Database connection failed, please check your network or configuration");
         }
     }
     catch
     {}
 }
Пример #2
0
        public void searchDatabase(object command)
        {
            string cmd = (string)command;

            setStatus("Searching......." + cmd, Color.Red, 50);

            if (mySQLFunction.connect())
            {
                try
                {
                    mySQLFunction.DUTds = new DataSet();
                    MySql.Data.MySqlClient.MySqlDataAdapter mySQLData = new MySqlDataAdapter(cmd, mySQLFunction.conn);
                    mySQLData.Fill(mySQLFunction.DUTds);
                    // dataGridViewTrackpad.DataSource = mySQLFunction.DUTds.Tables[0].DefaultView;
                    SetDataGridViewTrackpad();
                }
                catch (MySql.Data.MySqlClient.MySqlException ex)
                {
                    MessageBox.Show("ERROR: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Пример #3
0
 private void testDatabaseToolStripMenuItem_Click(object sender, EventArgs e)
 {
     try
     {
         MySQLFunction mySQLFunction1 = new MySQLFunction();
         if (mySQLFunction1.connect())
         {
             setStatus("Database connection succeed", Color.Green, 100);
             MessageBox.Show("Database connection succeed");
         }
         else
         {
             setStatus("Database connection failed, Please make sure your config are right", Color.Red, 0);
             MessageBox.Show("Database connection failed, please check your network or configuration");
         }
     }
     catch
     {}
 }