Populating two tools with one eventclick.

See more:

C#

SQL

Hi,

So far WINDOWSFORM code to populate a listbox1 on clicking a radio button is working fine.. code as follows,

private void AutoradioButton1_Click(object sender, EventArgs e)
{
    SqlConnection conn = new SqlConnection("Server=CHRIS-PC\\SQLEXPRESS;Database=Tblcat;" +
                         "Integrated Security=True");
    SqlCommand scmd = new SqlCommand("SELECT Description FROM Moviecat", conn);
    DataSet sds = new DataSet();
    conn.Open();
    SqlDataAdapter sadptr = new SqlDataAdapter(scmd);
    sadptr.Fill(sds, "Moviecat");
    if (sds.Tables["Moviecat"].Rows.Count == 0)
    {
        MessageBox.Show("There are no DB.");
    }
    else
    {
        this.listBox1.DataSource = sds.Tables["Moviecat"];
        this.listBox1.DisplayMember = "Description";
    }
    conn.Close();
}

The above works fine.

Now i want to populate checkedlistbox1 from a particular column from another table, on clicking the same radio button ( AutoradioButton1_Click).. ie( two population on one AutoradioButton1_Click)

can anyone help me with the code.. or include appropriate code with it.?
as where to start.

My another table say: table1, and column name : Rating.

Thanks
Vista