Useful hints regarding coding in CSharp/.net

language

arrays

creating array on the fly:

new object[] {element1, element2}

enums

todo

System.Data

DataView: filter by date

• see also http://www.csharp-examples.net/dataview-rowfilter/
• dd/MM/yyyy did not work on Mono on Mac
• example: U:\openpetraorg\csharp\ICT\Petra\Shared\lib\MPartner\Calculations.cs

           return new DataView(ATable, "((" + PPartnerLocationTable.GetDateEffectiveDBName() + " <= #" + DateTime.Now.Date.ToString(
                   "yyyy-MM-dd") + "# OR " + PPartnerLocationTable.GetDateEffectiveDBName() + " IS NULL) AND (" +