Configuring SQLdataadapter with nested query.

How to configure sqldatadapter with query like

"select name ,id from tlb1 where id in (select id from tlb2 where dept=@.dept)"

Is the nested subquery is not allowed while configuring sqldaadapter?

Swati

Hi Swati Jain,

Is the nested subquery is not allowed while configuring sqldaadapter?

I don't think so. I tested your code in my project and it works fine. There must be something wrong somewhere else in your code. Also a workaroud here is to use table join instead of nested sql.

Hope my suggestion helps