populate DataGrid from database in C#

[MastaKay]

I hv dropdownlist on a c# page connected to a database(MS Access).
I want to get values onto my datagrid when I select a value from the dropdownlist.The Item I select from the dropdown will determine what I get loaded onto the datagrid.

Please help with some code.

connect.ConnectionString = strng;
 
        OleDbCommand command = new OleDbCommand("Select * from Extensions Where FilterByKey = '" + DropDownList1.SelectedItem + "'", connect);
        connect.Open();
        command.Connection = connect;
        datareader = command.ExecuteReader();
        if (datareader.Read())
        {
            // This will filter database data by the FilterByKey and then populate the datagrid
                 GridView1.Items.Add(datareader2[0].ToString());****not working
                     LabelMessage.Text = "All values displayed";
            connect.Close();
            datareader.Close();

[kenobewan]

I believe that you will need to use the selectedinex event. Why are you trying to filter twice this should be done by the SQL statement? Why not just add the items?