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
 

dimpledevani

New member
Joined
Dec 27, 2011
Messages
1
Programming Experience
Beginner
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
 
Top Bottom