Dim c As New MySqlConnection("Server=localhost;Database=test;UID=test;PWD=test;")
        c.Open()
        Dim com As New MySqlCommand("SELECT COUNT(*) as c FROM toutcome WHERE AffID = '0001' AND CompletedDate >= CURDATE();", c)
        Dim myReader As MySqlDataReader = com.ExecuteReader(CommandBehavior.CloseConnection)
        myReader.Read()
        Label1.Text = myReader.Item(0).ToString()

        myReader.Close()

Dim c As New MySqlConnection("Server=localhost;Database=mdxmain;UID=MerryWoodTest;PWD=H0r$hamTest;")
        c.Open()
        Dim com As New MySqlCommand("SELECT COUNT(*) as c FROM toutcome WHERE AffID = '0001' AND WHERE CompletedDate >= '" & TextBox1.Text & "' AND CompletedDate <= '" & TextBox2.Text & "'", c)
        Dim myReader As MySqlDataReader = com.ExecuteReader(CommandBehavior.CloseConnection)
        myReader.Read()
        Label11.Text = myReader.Item(0).ToString()

        myReader.Close()