C#

OracleConnection oraCONNECTION;
OracleDataAdapter oraADAPTER;
string strCommand;


private void rdIndicators_CheckedChanged(object sender, EventArgs e)
{
    if (rdIndicators.Checked)
    {
        dataGrid1.CaptionText = "Population Indicators";
        strCommand = @"SELECT * FROM PPL_INDICATORS";
        popDGrid();
    }
}

private void rdInst_CheckedChanged(object sender, EventArgs e)
{
    if (rdInst.Checked)
    {
        dataGrid1.CaptionText = "Institutional Structure";
        strCommand = @"SELECT * FROM INS_STRUCT";
        popDGrid();
    }

}


private void popDGrid()
{
    oraCONNECTION = new OracleConnection(@"Data Source=orcl; Persist Security Info=True;User ID=DLDSP; Password=DLDSP;Unicode=True");
    oraADAPTER = new OracleDataAdapter(strCommand, oraCONNECTION);

    DSet.Clear();
    oraADAPTER.Fill(DSet);
    dataGrid1.DataSource = DSet.Tables[0];
    dataGrid1.Refresh();
    this.Refresh();
}