Click here to Skip to main content
14,549,480 members
   

C#

 
Questionquery to a xml database Pin
devilonline119-Feb-20 15:57
Memberdevilonline119-Feb-20 15:57 
AnswerRe: query to a xml database Pin
OriginalGriff19-Feb-20 20:04
mveOriginalGriff19-Feb-20 20:04 
GeneralRe: query to a xml database Pin
devilonline120-Feb-20 8:59
Memberdevilonline120-Feb-20 8:59 
GeneralRe: query to a xml database Pin
Richard Deeming21-Feb-20 0:55
mveRichard Deeming21-Feb-20 0:55 
AnswerRe: query to a xml database Pin
F-ES Sitecore19-Feb-20 23:08
mveF-ES Sitecore19-Feb-20 23:08 
AnswerRe: query to a xml database Pin
Alkimus15-Mar-20 5:16
professionalAlkimus15-Mar-20 5:16 
QuestionSystem.Web.Services.Protocols.SoapException: Format of the initialization string does not conform to specification starting at index 97. Pin
Member 1474982719-Feb-20 15:36
MemberMember 1474982719-Feb-20 15:36 
QuestionHow to do left and inner join in same query Pin
Mou_kol19-Feb-20 9:34
MemberMou_kol19-Feb-20 9:34 
See my linq query first
var query = (from r1 in dtMappedSectionNotEmpty.AsEnumerable()
                                 join r2 in dtData.AsEnumerable()
                                 on r1.Field<string>("Row").Trim().ToUpper() equals r2.Field<string>("RowCoordinate").Trim().ToUpper()
                                 join r3 in _Periods.AsEnumerable()
                                 on r2.Field<string>("StandardDate").Replace("A", string.Empty).Replace("E", string.Empty).Trim().ToUpper() equals r3.Replace("A", string.Empty).Replace("E", string.Empty).Trim().ToUpper()
                                 where r1.Field<string>("Tab").Trim().ToUpper() == strTab.Trim().ToUpper()
                                 select new BrokerData
                                 {
                                     RowNumber = r1.Field<string>("Row") ?? "0",
                                     TabName = r1.Field<string>("Matched Section") ?? "",
                                     StandardDate = r3.ToString(),
                                     BRTab = r1.Field<string>("Tab") ?? "",
                                     BRLineItem = r1.Field<string>("Broker Items") ?? "",
                                     Action = r1.Field<string>("Action") ?? "",
                                     StandardLineItem = r1.Field<string>("Matched Items") ?? "",
                                     StandardValue =r2.Field<string>("LineItemDateValue") ?? ""
                                 }).ToList();




in my above code there are 2 datatable and one list. now i am not being able to compose left and inner join in same query.

there will be left join between dtMappedSectionNotEmpty and dtData datatable. means left join between r1 & r2

again there will be inner join between dtData & _Periods means i want inner join between r2 & r3

so please see my code and give me another set same LINQ code where left join and inner join will be there in same query. thanks
AnswerRe: How to do left and inner join in same query Pin
Gerry Schmitz19-Feb-20 12:13
mveGerry Schmitz19-Feb-20 12:13 
GeneralRe: How to do left and inner join in same query Pin
Mou_kol21-Feb-20 22:42
MemberMou_kol21-Feb-20 22:42 
QuestionBest deployment guide for our winform application using CI/CD Pin
Mou_kol18-Feb-20 8:24
MemberMou_kol18-Feb-20 8:24 
AnswerRe: Best deployment guide for our winform application using CI/CD Pin
Richard MacCutchan18-Feb-20 10:25
mveRichard MacCutchan18-Feb-20 10:25 
QuestionSystem.FormatException: 'Input string was not in a correct format. Pin
OsvaldoFernandoQueta17-Feb-20 17:43
MemberOsvaldoFernandoQueta17-Feb-20 17:43 
AnswerRe: System.FormatException: 'Input string was not in a correct format. Pin
OriginalGriff17-Feb-20 20:35
mveOriginalGriff17-Feb-20 20:35 
GeneralRe: System.FormatException: 'Input string was not in a correct format. Pin
Member 798912217-Feb-20 23:17
MemberMember 798912217-Feb-20 23:17 
QuestionI want to open PDF-file on winforms axAcroPDF1.src (Adobe Reader) Pin
Member 1462552315-Feb-20 1:32
MemberMember 1462552315-Feb-20 1:32 
AnswerRe: I want to open PDF-file on winforms axAcroPDF1.src (Adobe Reader) Pin
Eddy Vluggen15-Feb-20 2:59
professionalEddy Vluggen15-Feb-20 2:59 
AnswerMessage Closed Pin
20-Feb-20 23:14
MemberMember 1475132520-Feb-20 23:14 
QuestionDifferent value from input Pin
chipp_zanuff14-Feb-20 6:15
Memberchipp_zanuff14-Feb-20 6:15 
AnswerRe: Different value from input Pin
OriginalGriff14-Feb-20 6:32
mveOriginalGriff14-Feb-20 6:32 
GeneralRe: Different value from input Pin
chipp_zanuff14-Feb-20 17:48
Memberchipp_zanuff14-Feb-20 17:48 
GeneralRe: Different value from input Pin
OriginalGriff14-Feb-20 20:21
mveOriginalGriff14-Feb-20 20:21 
AnswerRe: Different value from input Pin
Eddy Vluggen14-Feb-20 6:35
professionalEddy Vluggen14-Feb-20 6:35 
Questionauto fill data by using 3 layer in aso.net c# Pin
Member 1474357913-Feb-20 22:47
MemberMember 1474357913-Feb-20 22:47 
AnswerRe: auto fill data by using 3 layer in aso.net c# Pin
OriginalGriff13-Feb-20 23:39
mveOriginalGriff13-Feb-20 23:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.