Is it possible to use dataset.datatable records as subquery in a main sql query.example:
Assume Dataset.Datatable having 20 records in two fields (AgentCode and AgentName)
and in database there is a table named tblagent.
Now i like to get result like:
Select AgentCode, AgentName From tblAgent where AgentCode in (Select that dataset.datatable.col("AgentCode") )
Is it possible in Vb.Net - if so, how to do.
Expecting your valuable reply.