| Author: Neetu 05 Nov 2009 | Member Level: Diamond | Rating:  Points: 1 |
Try this type of code dear.
da1 = New OleDbDataAdapter("select * from emp", con)
da2 = New OleDbDataAdapter("select * from dept", con)
da1.Fill(data, "emp")
da2.Fill(data, "dept")
Dim dr As New DataRelation("demp", data.Tables("dept").Columns("deptno"), data.Tables("emp").Columns("deptno"))
data.Relations.Add(dr)
regards
Neetu
|
| Author: Anuraj 05 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
I think you can write the CREATE TRIGGER statement and call the executeNonQuery method to execute it against the DB.
Thanks
Anuraj
THIS POSTING IS PROVIDED "AS IS" WITH NO WARRANTIES, AND CONFERS NO RIGHTS.
BEWARE OF BUGS IN THE ABOVE CODE; I HAVE ONLY PROVED IT CORRECT, NOT TRIED IT.
dotnetthoghts
|
| Author: thiyagarajan 05 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
create a trigger statement for the table u want and call the execute nonquery method.
|
| Author: Preet 06 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
Thanks Neetu for your reply, the codes works well for me now.
regards
|
| Author: Neetu 09 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Its my pleasure.
regards
Neetu
|