C#

public void BD_Conexao()
    {
        try
        {
            OdbcConnection con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=xxxxx; database=lic; uid=es; password=1234; option = 3 ");
            con.Open();
        }

        catch (Exception ex)
        {
            Console.WriteLine("Erro na ligação à base de dados. \n{0}", ex.Message);
            return;
        }

    }
public void Consulta()
    {
        con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=xxx; database=lice; uid=estagio; password=1234; option = 3 ");
        con.Open();

        OdbcCommand Command = con.CreateCommand();
        Command.CommandText = "select lojas.Id, lojas.NIF, lojas.Loja, lojas.Bloqueado, lojas.DataFim, lojas.lastupdate, lojas.Nome";


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

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

        DataSet dataSet = new DataSet();
        adapter.Fill(dataSet);

        grid_lic.DataSource = dataSet;

        grid_lic.DataMember = dataSet.Tables[0].TableName;
      }

 private void bt_preencher_Click(object sender, EventArgs e)
 {
   BD_Conexao();

   string DataFim = dateTimePicker.Value.ToString("yyyy-MM-dd");
   string lastupdate = dateTimePicker2.Value.ToString("yyyy-MM-dd");
   Commandtext = "insert into lojas (NIF,Loja,bloqueado, DataFim, lastupdate, Nome) values (@NIF,@Loja,@Bloqueado,@DataFim,@lastupdate,@Nome)";

   OdbcCommand Command = new OdbcCommand(Commandtext, con);

   Command.CommandType = CommandType.Text;

   Command.Parameters.AddWithValue("@NIF", grid_lic.CurrentRow.Cells[1].Value);
   Command.Parameters.AddWithValue("@Loja", grid_lic.CurrentRow.Cells[2].Value);
   Command.Parameters.AddWithValue("@Bloqueado", checkBox_bloq.Checked);
   Command.Parameters.AddWithValue("@DataFim", grid_lic.CurrentRow.Cells[4].Value);
   Command.Parameters.AddWithValue("@lastupdate", grid_lic.CurrentRow.Cells[5].Value);
   Command.Parameters.AddWithValue("@Nome", grid_lic.CurrentRow.Cells[6].Value);

   Command.ExecuteNonQuery();
   Consulta();
}

private void Form1_Load(object sender, EventArgs e)
{
    comboBox1.SelectedItem = "Select Gender";

    using (SqlConnection con = new SqlConnection(conn))
    {

        SqlDataAdapter sda = new SqlDataAdapter("getdata", con);
        sda.SelectCommand.CommandType = CommandType.StoredProcedure;
        DataSet ds = new DataSet();
        sda.Fill(ds);
        ds.Tables[0].TableName = "Product";
        ds.Tables[1].TableName = "Category";

        dataGridView3.DataSource = ds.Tables["Product"];
        dataGridView4.DataSource = ds.Tables["Category"];


    }
    gridrowcolor();


}
public void gridrowcolor()
{
    DataGridViewCellStyle st = new DataGridViewCellStyle();
    st.Font = new Font("Arial", 12, FontStyle.Bold);

    for (int i = 0; i < dataGridView4.Rows.Count-1; i++)
    {
        //dataGridView4.RowsDefaultCellStyle.BackColor = Color.Orange;
        //dataGridView4.AlternatingRowsDefaultCellStyle.BackColor = Color.BurlyWood;

        int ii = Convert.ToInt32(dataGridView4.Rows[i].Cells[0].Value.ToString());
        if (ii % 2 == 0)
        {
            dataGridView4.Rows[i].DefaultCellStyle.BackColor = Color.Gray;
            dataGridView4.Rows[i].DefaultCellStyle = st;
        }
        else
            dataGridView4.Rows[i].DefaultCellStyle.BackColor = Color.Brown;
    }

    for (int i = 0; i < dataGridView3.Rows.Count - 1; i++)
    {


        dataGridView3.CellBorderStyle = DataGridViewCellBorderStyle.None;
        DataGridViewCellStyle style = new DataGridViewCellStyle();
        style.Font = new Font(dataGridView3.Font, FontStyle.Bold);

        int ii = Convert.ToInt32(dataGridView3.Rows[i].Cells[0].Value.ToString());
        if (ii % 2 == 0)
        {
            dataGridView3.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
            dataGridView3.Rows[i].DefaultCellStyle = style;
            dataGridView3.DefaultCellStyle.SelectionForeColor = Color.Chocolate;
        }
        else
            dataGridView3.Rows[i].DefaultCellStyle.BackColor = Color.Orange;
    }
}

private void receiptCancelRequestToolStripMenuItem_Click(object sender, EventArgs e)
{
    Form1 frm = new Form1();
    frm.MdiParent = this;
    frm.Show();

}

private void DisplayReport_Load(object sender, EventArgs e)
        {
            dataGridViewReport.DataSource = null;
            DataTable dt = ds.Tables[0];
            dataGridViewReport.DataSource = ds.Tables[0].DefaultView;

            this.reportViewer1.Reset();
            this.reportViewer1.LocalReport.ReportPath = Application.StartupPath +  @" \Report1.rdlc";
            ReportDataSource rds = new ReportDataSource("Precheck Report", dt);
            reportViewer1.LocalReport.DataSources.Clear();
            reportViewer1.LocalReport.DataSources.Add(rds);
            reportViewer1.RefreshReport();
        }