Relations multiple table using in C#

Question

Hi All... How can do I relations like fallowing image using C# code

Yakup BG · Answer

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_nobetprg_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(); }

Sandeep Singh Shekhawat · Answer

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 !  ); } }