Posted on: 4/15/2011 9:20:49 PM | Views : 331

I have some Linq code that I get from a SQL db. I then put it into an xml string and pass it back to my calling function. I am then trying to bind it to the Gridview. I keep getting 'processnumber' not found. Linq Query query = From f In lnqDataMgr.FileLogs _ Group Join s In lnqDataMgr.StatusLists On s.StatusID Equals f.StatusID Into os = Group _ From x In os.DefaultIfEmpty _ Where f.Cycle = strCycle And f.FCBFileName.Substring(9, 3) = strSite _ Order By f.FCBFileName _ Select Amount = Format(ValidCurrency(f.Amount), "##,###,###,###,##0.00"), _ FileStatus = f.ErrorMessage, _ Progress = x.StatusString, _ ABCFileName = f.ABCFileName, _ BoAResponse = f.FileName, _ ...

Go to the complete details ...