load data in datagridview in c#.net using windows application

See more:

C#

load data in datagridview in c#.net using windows application.


Faculty Code Combo box View (Button)

in combo box all faculty code will be displayed from the data base. working fine.

when i select the faculty code and click the view (Button) want to display selected faculty code in datagridview.

for that i written the code as follows;

private void Btn_View_Faculty_Click(object sender, EventArgs e)
        {
  sql = "select CONVERT(varchar(11), Date, 106)  AS Date_of_birth,Session,Faculty_Code from Tb_SCh_TIme_Table where Course = ' " + cb_Course_Name.Text + ' " order by Date,session";
            SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, con);

            SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);

            DataTable table = new DataTable();

            dataAdapter.Fill(table);

            bindingSource2.DataSource = table;

            Dgv_Faculty_Code.DataSource = bindingSource2;
        }

when i run and select the faculty code and click the view button.

in data grid view the selected faculty code details is not displaying.

why? form my above what is the mistake. i tried but it is not working.