C#

namespace WpfApplication
{
    public class GetToltipStatus : IValueConverter
    { 
        public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
             !!HERE I NEED THE CONNECTION CONN!!
        }
       
        public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            throw new NotImplementedException();
        }
    }




public partial class Tab_100 : System.Windows.Controls.UserControl
    {
        public NpgsqlConnection conn;

        public Tab_100(NpgsqlConnection conn100)
        {
            conn = conn100;
        }
    }

I have created Campaign in Mailchimp account and now I want to 
send Email to Campaign members Programatically in C#. Actually i am 
new to this concept and want to send newsletter to users who have 
subscribed to campaign. Please guide me for implement this.

What are basic steps for create and send newsletter on Mailchimp 
account and way to access it from C# with required methods.

public void filtrar_Click(object sender, EventArgs e)
        {
            DataView dv = new DataView(ds);
           
          
            //define a ordenação e o filtro
            dv.AllowNew = false;
            dv.AllowDelete = true;            
            dv.RowFilter = "NIF Like '" + textBoxNIF.Text + "*'";
            //exibe o resultado
            grid_lic.DataSource = dv;
        }

        public void Consulta()
        {
            //MessageBox.Show(grid_lic.CurrentRow.Cells[3].Value.ToString());
            con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=192.168.19.78; database=licenciamento; uid=estagio; password=1234; option = 3 ");
            con.Open();

            OdbcCommand Command = con.CreateCommand();
            Command.CommandText = "select lojas.Id, lojas.NIF, lojas.Loja, lojas.Bloquear, lojas.DataFim, lojas.lastupdate, lojas.Nome, " +
            " licenciamentoloja.EArtigo, licenciamentoloja.EFamilia, licenciamentoloja.EClientes, licenciamentoloja.EFornecedores, licenciamentoloja.Evendas," +
            "licenciamentoloja.ECompras, licenciamentoloja.EStocks, licenciamentoloja.ELiquidacao, licenciamentoloja.ECaixas, licenciamentoloja.EInfoStock," +
            "licenciamentoloja.ZSArtigos, licenciamentoloja.ZSClientes, licenciamentoloja.ZSStocks, licenciamentoloja.id from lojas inner join licenciamentoloja on lojas.NIF = licenciamentoloja.NIF and lojas.Loja = licenciamentoloja.loja";

            Command.CommandType = CommandType.Text;
            Command.Connection = con;

            OdbcDataAdapter adapter = new OdbcDataAdapter();
            adapter.SelectCommand = Command;

            DataSet ds = new DataSet();
            adapter.Fill(ds);
            grid_lic.DataSource = ds;
            grid_lic.DataMember = ds.Tables[0].TableName;