Relations multiple table using in C#

Thankyou  Sandeep you are right but I have 3 tables and i can't relations shown in the figure as you can see . in fact  I carry out relations separately ogretmen to program or program to nobet . if I want to all together gives an error. My code like this...
 public void vt_iliski()
      {
          try
         {
             string sorgu_ogretmen = "select * from ogretmen";
             string sorgu_program = "select * from program";
             string sorgu_nobet = "select * from nobet";


             ds_gnd = new DataSet();
             DataTable tablo = new DataTable();
             adpt_ogrt = new SqlCeDataAdapter(sorgu_ogretmen, baglan());
             adpt_prg = new SqlCeDataAdapter(sorgu_program, baglan());
             adpt_nbt = new SqlCeDataAdapter(sorgu_nobet, baglan());

             adpt_ogrt.Fill(ds_gnd, "ogretmen");
             adpt_prg.Fill(ds_gnd, "program");
             adpt_nbt.Fill(ds_gnd, "nobet");

                /*  **********  relation -1 ****************** */

             DataColumn ogrt_kolon = ds_gnd.Tables["ogretmen"].Columns["ogrt_ID"];
             DataColumn prg_kolon = ds_gnd.Tables["program"].Columns["ogrt_ID"];
          
             iliski1 = new DataRelation("Ogretmen_To_Program", ogrt_kolon, prg_kolon);

             
             ForeignKeyConstraint kisitla = new ForeignKeyConstraint(ogrt_kolon, prg_kolon);

             kisitla.UpdateRule = Rule.Cascade;
             kisitla.DeleteRule = Rule.Cascade;
             kisitla.AcceptRejectRule = AcceptRejectRule.Cascade;

             ds_gnd.Tables["program"].Constraints.Add(kisitla);
             ds_gnd.EnforceConstraints = true;
       
              ds_gnd.Relations.Add(iliski1);
            
             yonet_ogrt = new BindingSource(ds_gnd, ds_gnd.Tables["ogretmen"].ToString());
             yonet_prg = new BindingSource(yonet_ogrt, "Ogretmen_To_Program");

          

             /*  **********  relation-2 ****************** */
                  DataColumn prg_kolon_nobet = ds_gnd.Tables["program"].Columns["prg_ID"];              
              DataColumn nobet_kolon = ds_gnd.Tables["nobet"].Columns["prg_ID"];
            
            iliski2 = new DataRelation("Program_To_nobet",prg_kolon_nobet , nobet_kolon );


    ForeignKeyConstraint kisitla2 = new ForeignKeyConstraint(prg_kolon_nobet, nobet_kolon);


              kisitla2.UpdateRule = Rule.Cascade;
              kisitla2.DeleteRule = Rule.Cascade;
              kisitla2.AcceptRejectRule = AcceptRejectRule.Cascade;

              ds_gnd.Tables["nobet"].Constraints.Add(kisitla2);
              ds_gnd.EnforceConstraints = true;
           
              ds_gnd.Relations.Add(iliski2);

              yonet_prg = new BindingSource(ds_gnd, ds_gnd.Tables["Program"] .ToString());
              
              yonet_nbt = new BindingSource(yonet_prg  , "Program_To_nobet");
                
           }
         catch (Exception hata)
         {
             MessageBox.Show("Okul Günlük Nöbet Defteri iliskilendirme Hatasi olustu : " + hata.Message + " " + hata.StackTrace );

         }
                    
         finally
         {
             baglanti.Dispose();
             adpt_ogrt.Dispose();
             adpt_prg.Dispose();
             adpt_nbt.Dispose();
                
         }

You should use DataRelation object which defines relationship among tables these are in DataSet.


http://etutorials.org/Programming/ado+net/Part+I+ADO.NET+Tutorial/Chapter+11.+DataRelations/11.1+DataRelation+Object+Overview/

public void defineRelationShip()

        {

            string connetionString = null;

            SqlConnection connection;

            SqlCommand command;

            SqlDataAdapter adapter = new SqlDataAdapter();

            DataSet ds = new DataSet();

            string firstSql = null;

            string secondSql = null;

            connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";

            firstSql = "Your First SQL Statement Here";

            secondSql = "Your Second SQL Statement Here";

            connection = new SqlConnection(connetionString);

            try

            {

                connection.Open();

                command = new SqlCommand(firstSql, connection);

                adapter.SelectCommand = command;

                adapter.Fill(ds, "Table1");

 

                adapter.SelectCommand.CommandText = secondSql;

                adapter.Fill(ds, "Table2");

 

                adapter.Dispose();

                command.Dispose();

                connection.Close();

                //creating data relations

                DataRelation relation;

                DataColumn table1Column;

                DataColumn table2Column;

                //retrieve column

                table1Column = ds.Tables["Table1"].Columns[0];//Column for relation

                table2Column = ds.Tables["table2"].Columns[0];//column for relation

                //relating tables

                relation = new DataRelation("relation", table1Column, table2Column);

                //assign relation to dataset

                ds.Relations.Add(relation);

 

                Response.Write("Data relation completed");

            }

            catch (Exception ex)

            {

                Response.Write("Can not open connection ! ");

            }

        }