How to compare two database objects_type and objects_name

[kannabiran]

Hi,
Im using vb.net as a front end and oracle as a back end,have to compare the two database object type and object name if its available means i need as true else false and should be entered in the isavail column...
Eg..
obj_type obj_name isavail
------------ --------------- ---------
package package_name
index Index_name

like wise im having in the datagrid,then im selecting

adp=new oledbdataadapter("select object_type,object_name from user_objects",con)
adp.fill(ds)

how to i compare these selected user objects to that datagrid available objects_type and object _name and is it available means i need to fill yes in the isavail column in the datagrid else no..
Help me plzzz..
Thks in adv...
Kannabiran.

[kenobewan]

One way would be to use Try Catch blocks and set your variable to false if it fails...

Hope that this helps.