protected override void OnBarUpdate()
{
//create a MySQL connection
MySqlConnection connection = new MySqlConnection("Server=server;Database=database;Port=port;Uid=userid;Password=password");
//create a MySQL insert command with a query string
string myInsertQuery = String.Format ("INSERT INTO table (column1, column2) values ('value1', 'value2')");
MySqlCommand command = new MySqlCommand(myInsertQuery);
command.Connection = connection;
connection.Open();
//insert info
command.ExecuteNonQuery();
//close the connection
connection.Close();
}
protected override void OnStartUp()
{
//create a MySQL connection
MySqlConnection connection = new MySqlConnection("Server=server;Database=database;Port=port;Uid=userid;Password=password");
connection.Open();
}
Comment