Find in Tables

shersu

New member
Joined
Oct 30, 2011
Messages
3
Programming Experience
5-10
Hi,


I have a function that returns all the database tables with the data items in it. Is it possible to search for a value in all tables and return the table name and the datarow that contains the value?


Thanks
 
Hi
you can use the select() method of datatable
justs fire the query and it returns an array of datarow if exists


e.g:

DataRow dr[]=dtTable.select("columnname='"+value+"'");
you can use loops for multi datatables;

Hope this helps
 
Back
Top Bottom