how can i use loop in c# database selection

Question

my code is like this:

    dt1 = dt1
            .AsEnumerable()
            .Where(r=>!String.IsNullOrEmpty(r.Field<string>("Transaction_x0020_Type"))
                        &&(r.Field<string>("Transaction_x0020_Type").ToLower().Contains(YrStrList[0].ToLower())
                        ||r.Field<string>("Transaction_x0020_Type").ToLower().Contains(YrStrList[1].ToLower())
                        ||r.Field<string>("Transaction_x0020_Type").ToLower().Contains(YrStrList[2].ToLower())
                        ||r.Field<string>("Transaction_x0020_Type").ToLower().Contains(YrStrList[3].ToLower())))
            .AsDataView()
            .ToTable();

and I hope can put the following part in a loop:

     &&(r.Field<string>("Transaction_x0020_Type").ToLower().Contains(YrStrList[0].ToLower())
                        ||r.Field<string>("Transaction_x0020_Type").ToLower().Contains(YrStrList[1].ToLower())
                        ||r.Field<string>("Transaction_x0020_Type").ToLower().Contains(YrStrList[2].ToLower())
                        ||r.Field<string>("Transaction_x0020_Type").ToLower().Contains(YrStrList[3].ToLower())))

what are you trying to accomplish by putting that code into a loop? — Chris Hinton
– Chris Hinton, Commented May 27, 2014 at 16:18
"Thanks" at the bottom of the post is not necessary and is frowned upon by the community. Adding it as an edit (and the only change in the edit!) is definitely not needed/appropriate. I have rolled the change back for you. — BradleyDotNET
– BradleyDotNET, Commented May 27, 2014 at 16:21
A bit of an explanation of what you are trying to accomplish would make a good edit though... — BradleyDotNET
– BradleyDotNET, Commented May 27, 2014 at 16:22

D Stanley · Accepted Answer · 2014-05-27 16:20:16Z

1

Assuming you're checking all values in YrStrList and not just the first 4 (of possibly more than 4):

&&(YrStrList.Any(y => r.Field<string>("Transaction_x0020_Type")
                       .ToLower()
                       .Contains(y.ToLower())))

answered May 27, 2014 at 16:20

D Stanley

153k12 gold badges189 silver badges257 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how can i use loop in c# database selection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related