NitendraTRIC 0 Newbie Poster

i m creating project in vb.net i m facing problem with related tables how the data will insert in muliple tables. and correct data are displaying in text boxes from multiple tables can any body help me plz.....

con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Lecture'sManagement\Lecture'sManagementSystem\LectureManagement.mdb;Persist Security Info=True")
        da = New OleDbDataAdapter("select * from Course_Details", con)
        ds = New DataSet()
        da.Fill(ds, "Course_Details")
        da = New OleDbDataAdapter("select * from Subject_Details", con)
        da.Fill(ds, "Subject_Details")
        dr = New DataRelation("Masterchild", ds.Tables("Course_Details").Columns("Course_ID"), ds.Tables("Subject_Details").Columns("Course_ID"))
        ds.Relations.Add(dr)
        dr.ChildKeyConstraint.UpdateRule = Rule.Cascade
        dr.ChildKeyConstraint.DeleteRule = Rule.Cascade
        DataGridView1.DataSource = ds.Tables(0)
        DataGridView2.DataSource = ds.Tables(1)

        lblcourseID.Text = ds.Tables(0).Rows(SubNo)(0)
        cmbcourse.Text = ds.Tables(0).Rows(SubNo)(1)
        txtSubjectID.Text = ds.Tables(1).Rows(SubNo)(0)
        txtSubject.Text = ds.Tables(1).Rows(SubNo)(2)