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 {} }
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); } } }
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 {} }