Useful hints regarding coding in CSharp/.net
Jump to navigation
Jump to search
language
arrays
todo
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 (" +