String/object actief buiten public void

[njitram]

Hallo mensen,
Ik ben een beetje aan het proberen met C#, en het zou
fijn zijn als jullie mij kunnen helpen
Hoe krijg ik connectie string/object uit mijn public voids actief?

Fout:

Error	1	The name 'connection' does not exist in the current context	C:\Users\Software\Desktop\ConnectieMySQL\MySQL verbinding\MySQL verbinding\MainFrame.cs	34	36	MySQL verbinding

Code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Xml;
using System.IO;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace MySQL_verbinding
{
    public partial class MainFrame : Form
    {
        public MainFrame()
        {
            InitializeComponent();
        }

        public void button1_Click(object sender, EventArgs e)
        {
			string MyConString = "SERVER=localhost;" +
				"DATABASE=*****;" +
				"UID=root;" +
				"PASSWORD=*****;";
			MySqlConnection connection = new MySqlConnection(MyConString);			
        }


        public void get_Click(object sender, EventArgs e)
        {
            MySqlCommand command = connection.CreateCommand();
            MySqlDataReader Reader;
            command.CommandText = "select * from flessen";
            connection.Open();
            Reader = command.ExecuteReader();
            while (Reader.Read())
            {
                string thisrow = "";
                for (int i = 0; i < Reader.FieldCount; i++)
                    thisrow += Reader.GetValue(i).ToString() + ",";
                thisrow += ";";
                listBox1.Items.Add(thisrow);
            }
        }



        public void close_Click(object sender, EventArgs e)
        {
            connection.Close();
        }
    }
}

 

[GertW]

als volgt:

MySqlConnection connection; = new MySqlConnection(MyConString);		
        
public void button1_Click(object sender, EventArgs e)
{
    String MyConString = "SERVER=localhost;" +
                                    "DATABASE=*****;" +
				    "UID=root;" +
				    "PASSWORD=*****;";
    connection = new MySqlConnection(MyConString);
}