linq query i want to write to the below query

Question

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

Bhavesh Jadav · 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 Jadav · Answer

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

Bhavesh Jadav · Answer

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 mirza · Answer

will you give me the source code to print webgrid with all pages

Bhavesh Jadav · Answer

Hello Ejaz, I am happy to help you. Thanks for your replay and accept my answer.