I need to create a query based on ceratin search condition in which i get a list at some condition in the middle of the query construction ..
I first create a query by using stringBuilder and append the string based on the various condition and in one such condition i get list and
i have appened in the sting as list and based on few conditions the query is now generated and i could not get the correct answer
I need to execute at this condition
Note : It should not give the condition like this
reply to use the list while appending query in string builder itself.
I have used and program runs but value is 0 ...as i give list as condition in query ...If i give as parameter its working correct