Archive for the ‘c#’ Category
Thursday, January 14th, 2010
If you are trying to query a MS Excel (.xls, .xlsx, .xlsb) or MS Access (.mdb, .accdb) file on a 64-bit server and are getting one of the following error messages:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Then it ...
Posted in Code, c# | 5 Comments »
Thursday, December 11th, 2008
I recently saw a piece of code in a project that was throwing an exception that I did not understand:
string boolString = (string)DataBinder.Eval(DataItem, "IsNew");
One would expect that boolString would be assigned the value "True" or "False" depending on the value of the IsNew property of the DataItem object. However, this ...
Posted in c# | No Comments »
Thursday, February 7th, 2008
On a recent project, I had the need to detect whether or not the application is idle, and if so, for how long has the idle state persisted. Idle in my case is defined as no mouse movement or keyboard activity when any of the forms of the application are ...
Posted in c#, windows forms | 6 Comments »
Thursday, November 15th, 2007
I have had to look up on DateTime formatting on MSDN so many times, I have lost track. So I am putting the links and some of the key information here for my own future reference.
Posted in Code, c# | No Comments »
Thursday, August 2nd, 2007
I was working on an ASP.net application (1.1) the other day, changing the UI display of a page. This page basically consisted of a Repeater being populated with data from the DB, and binding javascript actions and styling info to the different rows to be output (each overall it was ...
Posted in Code, asp.net, c# | No Comments »
Sunday, June 3rd, 2007
In C# using .Net 2.0+, there is now built-in support for Generics collections using the System.Collections.Generic namespace. I use the List type most often, as a strongly-typed substitute for the ArrayList. Since it is strongly-typed, you now have design-time type-checking for enumerations like this (no casting necessary):
List<int> Foos = new ...
Posted in Code, c# | No Comments »