linq query i want to write to the below query

ejaz mirza

select ID,DocDate,Grade,StockLocationName from dispatch where Status ='Dispatched' and OrderFlag='PreOrder' and DispatchOrderID NOT IN(Select PreOrderDOID from orders WHERE PreOrderDOID IS NOT NULL)

anyone write the query for this

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhavesh Jadav8y ago
Accepted answer
Hello ejaz ,

also try below code
var output = (from d in dispatch where d.Name='Dispatched' and d.OrderFlag='PreOrder' and d.DispatchOrderID NOT IN(
from o in orders where isnull(o.PreOrderDOID,0)!=0 SELECT O.PreOrderDOID
) select d.Id,d.DocDate,d.Grade,d.StockLocationName);
Thanks.
Bhavesh Jadav8y ago
Hello Ejaz,

I replayed to you of 'print web grid with all pages' at question post in below link please check it.
https://www.c-sharpcorner.com/forums/i-want-to-print-the-webgrid-with-all-pages
Thanks.
ejaz mirza8y ago
will you give me the source code to print webgrid with all pages
Bhavesh Jadav8y ago
Hello Ejaz,

I am happy to help you.

Thanks for your replay and accept my answer.
Bhavesh Jadav8y ago
Hello ejaz ,

try below code
DataRow[] drs = dispatch.Select("Name='Dispatched' and OrderFlag='PreOrder' and DispatchOrderID NOT IN( orders.select(o -> o.PreOrderDOID and isnull(PreOrderDOID,'')<>'')");

if (drs.Length > 0)
{
   foreach(DataRow dr in drs)
   {
        string Id = dr["ID"].ToString();
        string DocDate = dr["DocDate"].ToString();
        string DocDate = dr["DocDate"].ToString();
        string DocDate = dr["DocDate"].ToString();
   }
}
Thanks