C#

private void Form1_Load(object sender, EventArgs e)
        {
            string myConnectionString = "SERVER=localhost;" + "DATABASE=database;" + "UID=root;" + "PASSWORD=123123;";
            MySqlConnection conn;
            conn = new MySqlConnection();
            conn.ConnectionString = myConnectionString;

            try
            {
                conn.Open();

                string sql = "SELECT * FROM table";
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                MySqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    ListViewItem item = new ListViewItem("" + rdr[0]); // by the way why it doesn't work if i omit "" + ?
                    item.SubItems.Add("" + rdr[1]); // i have to add empty string for it to work...
                    item.SubItems.Add("" + rdr[2]);
                    item.SubItems.Add("" + rdr[3]);
                    item.SubItems.Add("" + rdr[4]);
                    item.SubItems.Add("" + rdr[5]);
                    item.SubItems.Add("" + rdr[6]);
                    item.SubItems.Add("" + rdr[7]);
                    item.SubItems.Add("" + rdr[8]);
                    item.SubItems.Add("" + rdr[9]);
                    item.SubItems.Add("" + rdr[10]);
                    listView1.Items.Add(item);
                }
                rdr.Close();

            }
            catch (MySqlException ex)

private void addButton_Click(object sender, EventArgs e)
        {
            string myConnectionString = "SERVER=localhost; DATABASE=database; UID=root; PASSWORD=123123;charset=utf8";
            MySqlConnection conn;
            conn = new MySqlConnection();
            conn.ConnectionString = myConnectionString;

            try
            {
                conn.Open();
                string sql = "INSERT INTO table VALUES ('', '" + textBox1.Text + "', '" +textBox2.Text + "', '" + textBox3.Text + "', '0', '0', '0', '0', '0', '0', '0')";
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)

// This line simply creates the dialog on the C# side
HANDLE handle = CreateProgressDialog();
for (int i = 0; i < 100000; ++i)
{
   int val = i%100;   
   // Just set the progress bar value between 1 and 100 inclusive
   SetProgressValue(handle, val+1);
}

// Set the value of the progress bar to the specified value.
public void SetProgressValue(IntPtr handle, int value)
{            
   pdt.SetProgressValue(value);
   pdt.Refresh();   
}