C# - Conexão Simples com BD

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace Prophix___Periodo
{
public partial class frmProphixPeriodo : Form
{
// Variáveis Globais
string StringConexao, Senha;
SqlConnection Conexao;

public frmProphixPeriodo()
{
InitializeComponent();
}

private void ConexaoBD_Open()
{
StringConexao = "Server=XX\XX;Database=;User ID=RM;Password=XX;Trusted_Connection=False";

Conexao = new SqlConnection(StringConexao);

Conexao.Open();
}

private void ConexaoBD_Close()
{
Conexao.Close();
}

private void Form1_Load(object sender, EventArgs e)
{
Senha = "rmenella";
dtpInicial.Value = DateTime.Now.Date;
dtpFinal.Value = DateTime.Now.Date;

ConexaoBD_Open();

SqlCommand QueryColigada = new SqlCommand("SELECT CODCOLIGADA, NOMEFANTASIA FROM GCOLIGADA ORDER BY CODCOLIGADA", Conexao);

SqlDataReader DadosColigada = QueryColigada.ExecuteReader();

while (DadosColigada.Read())
{
cbBox.Items.Add(DadosColigada["CODCOLIGADA"] + " - " + DadosColigada["NOMEFANTASIA"]);
}

ConexaoBD_Close();
}

private void btnExecutar_Click(object sender, EventArgs e)
{
int ColigadaSelecionada;
DateTime DataInicial, DataFinal;

DataInicial = dtpInicial.Value;
DataFinal = dtpFinal.Value;
ColigadaSelecionada = cbBox.SelectedIndex;
//label1.Text = Convert.ToString(ColigadaSelecionada);
lblStatus.Text = "EM EXECUÇÃO";

try
{
ConexaoBD_Open();
SqlCommand StoredProc = new SqlCommand("SP_INTEGRACAO_RM_PROPHIX_PERIODO", Conexao);
StoredProc.CommandType = CommandType.StoredProcedure;
StoredProc.Parameters.AddWithValue("@CODCOLIGADA", ColigadaSelecionada);
StoredProc.Parameters.AddWithValue("@DATAINICIAL", DataInicial);
StoredProc.Parameters.AddWithValue("@DATAFINAL", DataFinal);
StoredProc.Parameters.AddWithValue("@CODHISTP", "");
StoredProc.CommandTimeout = 1000;
StoredProc.ExecuteNonQuery();
lblStatus.Text = "EXECUTADO COM SUCESSO!";
}
catch (SqlException ErroSQL)
{
lblStatus.Text = ErroSQL.Message;
}
finally
{
ConexaoBD_Close();
}
}

private void maskedTextBox1_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
{
}

private void textBox1_TextChanged(object sender, EventArgs e)
{
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
//label1.Text = Convert.ToString(cbBox.SelectedIndex);
}

private void frmProphixPeriodo_FormClosed(object sender, FormClosedEventArgs e)
{
}

private void maskedTextBox1_MaskInputRejected_1(object sender, MaskInputRejectedEventArgs e)
{
}

private void maskedTextBox1_TextChanged(object sender, EventArgs e)
{
if (mtbSenha.Text == Convert.ToString(Senha))
{
btnExecutar.Enabled = true;
}
else
{
btnExecutar.Enabled = false;
}
}

}
}