Multiple queries

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I have several queries as sql strings. I need to execute these, then take
the results and do further queries on them. In access we generate tables
from first set of queries then we use these table into second level of
queries and so on. How do you do this kind of stuff in vb.net?

Thanks

Regards
 
Currently I am filling up datatables from the first set of queries, as
follows;

objAdapter = New OleDbDataAdapter(strCatsExc, m_objConnection)
objAdapter.Fill(MyDataTable)

Can I use the datatables in the second level of queries (syntax?) or do I
need to use another way?

Thanks

Regards
 
Back
Top