Interesting task. Try following code: List<string> list = Enumerable.Range(1, 6).Select(e => ((char)(‘A’ + e – 1)).ToString()).ToList(); List<string> temp = new List<string>(); int count = list.Count; int total = 1 << list.Count; for (int i = 0; i < total; i++)…
Maybe something like this: var result= ( from s in db.Stands join cp in db.ContractProducts on s.Id equals cp.StandId join p in db.Products on cp.ProductId equals p.Id where s.EventId == 1 group p by p.Description into g select new {…
You are not returning the sorted collection. IEnumerable<Customer> result = orderings[sortExpression](customerQuery.Skip(startRows).Take(maxRows)); return result; 3 solved My sorting is not returning correctly in Linq [closed]
I used this Code and it Worked for me. DataRow row = dt.AsEnumerable().FirstOrDefault (r => (DateTime)r[“date”] == timeToCompare.Date & r.Field<string>(“plannum”) == “0995” & tp >= r.Field<TimeSpan>(“MorningStart”) & tp < r.Field<TimeSpan>(“MorningEnd”)); And then using this to get values : sh_starttime =…
You could also do a cross join with a where condition similar to your inner join condition var q1 = from billMap in tblOfferingBillingBehaviorMapping from lkpBill in tblLookUpBillingBehavior where billMap.LkpBillingBehaviorId == lkpBill.LkpBillingBehaviorId || billMap.LkpBillingBehaviorId =lkpBill.ParentRootId select new { billMap, lkpBill…
First, let’s define what we need. We need a table (view) with these fields: ProductId, ProductName, ProductViewCount, and RootCategoryId. Imagine, the Category table has RootCategoryId field already. Then we can use this query to receive the result: SELECT P.Id AS…
Turn this to false AutoGenerateColumns=”True” And add your own Bound columns to the Gridview. You will be able to give the columns whatever names you want solved variable name with a white space [closed]
You are not using the result of query IQueryable<StammdatenEntityModel> query = dbSet; query = query.OrderByDescending(s => s.CreateDateTime); query = query.Where(s => s.Deleted == false); if(!String.IsNullOrEmpty(keyword)) { query = query.Where(s => s.SerialNumber.Contains(keyword)); //simplified for SO } query = query.Skip(skip); query =…
txtresult is the value of Name Property of used TextBox control in this code. You need to add a TextBox in your application and assign it Name property value ‘txtresult’ for this code to work. 2 solved linq beginner, foreach…
If you are going to be dealing with these objects often then I would definitely make classes to represent them to make it easier to deserialize the JSON strings. If not then you can just roll something quick and dirty.…
You will need a row comparer. We’ll keep in mind that all rows have same length: public class RowComparer : IComparer<IEnumerable<int>> { public int Compare(IEnumerable<int> x, IEnumerable<int> y) { // TODO: throw ArgumentNullException return x.Zip(y, (xItem, yItem) => xItem.CompareTo(yItem)) .Where(c…
That happens because you do a string comparison – you should change that to a int comparison string[] arr = { “3”, “1”, “6”, “10”, “5”, “13” }; var result = arr.OrderBy(int.Parse).ToArray(); 1 solved Sort a String Array containing Numbers…
Query expression is much simpler in this case. I don’t recommend you to use lambdas with many joins from l in db.Listing join p in db.Place on l.PlaceId equals p.Id join pb in db.Place on p.ParentPlaceId equals pb.Id join a…
Based on “I am trying to get the null, empty string, and source components out of a List” I assume you mean you want a list with these 3 specific values. var allItems = itemsList .Where(s => string.IsNullOrEmpty(s[Constants.ProductSource]) || s[Constants.ProductSource]…
Do you mean something like this: var song = “foo2.mp3”; var number = 2; var query = from x in xd.Root.Elements(“file”) where x.Element(“song”).Value == song from y in x.Elements(“listen”) where (int)y.Element(“number”) == number select y.Element(“data”); Which would give you: solved…