C#

Quote:

and set an integer field in the target record based on the text field selected in a combobox.

Quote:

One can display the appropriate text values with the drop down, but nothing gets set.

What's making me crazy is that that form, if pulled out of the project, made a standalone in its own project, hitting the same database, of identical dataset and everything else I can find, works fine.

public class Doc
    {
    public string Title { get; set; }
    public string Date { get; set; }
    public Doc(string t, string d)
        {
        Title = t;
        Date = d;
        }
    }

List<Doc> docs = new List<Doc>() { new Doc("Title1", "2014-1-10"),
                                   new Doc("Title2", "2013-12-31")};
var inYear = docs.Where(d => DateTime.Parse(d.Date).Year == DateTime.Now.Year);

littleGreenDude wrote:

I guess it makes life easier in other areas of code.

DateTime earliest = new DateTime(2013, 12, 1);
DateTime latest = new DateTime(2014, 1, 14);
var inYear = docs.Where(d => DateTime.Parse(d.Date) >= earliest && DateTime.Parse(d.Date) < latest);

DateTime earliest = new DateTime(2013, 12, 23);
DateTime latest = new DateTime(2014, 1, 14);
var inYear = docs.Where(d => DateTime.Parse(d.Date) >= earliest).Where(d => DateTime.Parse(d.Date) < latest);

using System;
using System.Collections.Generic;
using System.Linq;

namespace LinqDateTest
{
    class Program
    {
        private readonly Dictionary<string, MySimpleClass> _mySimpleClasses = new Dictionary<string, MySimpleClass>();
        static void Main(string[] args)
        {
            new Program().AllocAndTest();
        }

        private int _index = 1;
        public void AllocAndTest()
        {
            Alloc("10/03/2024");
            Alloc("10/12/2013");
            Alloc("11/12/2013");
            Alloc("12/12/2013");

            var results = (from p in _mySimpleClasses
                          let myDate = DateTime.Parse(p.Value.MyStringDate)
                          where myDate > DateTime.Now.Subtract(TimeSpan.FromDays(100)) && myDate < DateTime.Now
                          select p.Value).ToList();
            foreach (var value in results)
            {
                Console.WriteLine("Index {0}, Value {1}", value.Index, value.MyStringDate);
            }

            Console.Read();
        }

        private void Alloc(string dateValue)
        {
            _mySimpleClasses.Add(dateValue, new MySimpleClass { MyStringDate = dateValue, Index = _index++ });
        }
    }

    public class MySimpleClass
    {
        public string MyStringDate;
        public int Index;
    }
}

public static class DateExtensions
{
    public static DateTime ToSafeDate(this string value)
    {
        DateTime parsedDate;
        if (!DateTime.TryParse(value, out parsedDate))
        {
            parsedDate = DateTime.MinValue;
        }
        return parsedDate;
    }
}

var results = (from p in _mySimpleClasses
              let myDate = p.Value.MyStringDate.ToSafeDate()
              where myDate > DateTime.Now.Subtract(TimeSpan.FromDays(100)) && myDate < DateTime.Now
              select p.Value).ToList();