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

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

Relations multiple table using in C#

Answers (2)