Помогите плиз совсем запарился)

            string commandtext1 = "Select * from Teacher";
            string commandtext2 = "Select * from Predmet";
            string commandtext3 = "Select * from Prepod_Predmet";

            SqlConnection connect = new SqlConnection(connectstr);
            SqlCommand comanda_1 = new SqlCommand();
            SqlCommand comanda_2 = new SqlCommand();
            SqlCommand comanda_3 = new SqlCommand();
 
            comanda_1.Connection = connect;
            comanda_1.CommandText = commandtext1;
            comanda_2.Connection = connect;
            comanda_2.CommandText = commandtext2;
            comanda_3.Connection = connect;
            comanda_3.CommandText = commandtext3;

            SqlDataAdapter adapter_1 = new SqlDataAdapter();
            SqlDataAdapter adapter_2 = new SqlDataAdapter();
            SqlDataAdapter adapter_3 = new SqlDataAdapter();
            adapter_1.SelectCommand = comanda_1;
            adapter_2.SelectCommand = comanda_2;
            adapter_3.SelectCommand = comanda_3;
            connect.Open();

            DataSet ds = new DataSet();
           

            adapter_1.TableMappings.Add("Table", "Teacher");
            adapter_1.Fill(ds);
            adapter_2.TableMappings.Add("Table", "Predmet");
            adapter_2.Fill(ds);
            adapter_3.TableMappings.Add("Table", "Prepod_Predmet");
            adapter_3.Fill(ds);

             DataColumn ds_ID_Prep = ds.Tables["Teacher"].Columns["ID_Prep"];
             DataColumn ds_ID_Predmet = ds.Tables["Predmet"].Columns["ID_Predmet"];
             DataColumn ds_Pred_Pred_ID_Prep = ds.Tables["Prepod_Predmet"].Columns["ID_Prep"];
             DataColumn ds_Pred_Pred_ID_Pred = ds.Tables["Prepod_Predmet"].Columns["ID_Predmet"];
             DataColumn ds_Pred_Pred_ID = ds.Tables["Prepod_Predmet"].Columns["ID"];

             DataRelation relation = new DataRelation("Расшифровка" , ds_Pred_Pred_ID, ds_ID_Prep);
             ds.Relations.Add(relation);

             DataViewManager dsview = ds.DefaultViewManager;
             dataGridView4.DataSource = dsview;
             dataGridView4.DataMember = "Prepod_Predmet";
             connect.Close();

Все нашел 
причина в том что сам DataGridview не поддерживает такой фишки)