Databases
StackOverflow2013
Postsdbo
PONull values In Return Results
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONull values In Return Results
    text
    copied!<p>here's My Code:</p> <pre><code>Dim QSD = From VM In cntxtVessel.VesselMasters _ Group Join cnt In cntxtVessel.CountryMasters On VM.CountryCode Equals cnt.CountryCode Into Cntry = Group _ From CM In Cntry.DefaultIfEmpty _ Group Join D In cntxtVessel.DestinationMasters On VM.DestinationCode Equals D.DestinationCode Into Dest = Group _ From DM In Dest.DefaultIfEmpty _ Group Join Car In cntxtVessel.CarrierMasters On VM.ClientCode Equals Car.CarrierCode Into Cr = Group _ From CS In Cr.DefaultIfEmpty _ Where VM.VesselCode &lt;&gt; 0 _ Order By VM.VesselName Ascending _ Select VesselCode = VM.VesselCode, VesselID = VM.VesselID, VesselName = VM.VesselName, ServiceType = VM.ServiceType, ClientCode = CType(CS.CarrierCode, Int32), Agent = CS.CompanyName, RefNo = VM.RefNo, VesselType = VM.VesselType, Length = VM.Lenght, Width = VM.Weight, Height = VM.Height, VesselBuiltDate = VM.VesselBuiltDate, AgeOfShip = VM.AgeOfShip, ShipBuilder = VM.ShipBuilder, CountryCode = CType(CM.CountryCode, Int32?), CountryName = CType(CM.CountryName, String), DestinationCode = CType(VM.DestinationCode, Int32?), DestinationName = DM.DestinationName, Flag = VM.Flag, CallSign = VM.CallSign, IMONo = VM.IMONo, NRT = VM.NRT, ContactPerson = VM.ContactPerson, MobileNo = VM.MobileNo, TPNo = VM.TPNo, Fax = VM.Fax, Email = VM.Email, Web = VM.Web, Remarks = VM.Remarks, InActive = VM.InActive ugrdVessel.DataSource = QSD </code></pre> <p>the above (left outer Join) code return the null value in some column <em>(ex. <code>Country Code=Null, DestinationCode=null,Agent=Null</code>)</em> how do i prenevt this null return values</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload