Zawód.Programista.NET() Profession, passion, appointment – notes about my adventures with. net

24Mar/111

Application on two monitors

Currently, you can see more and more people working in offices on two or more monitors. Such work is more convenient and efficient. Sam, as a developer I would not be able to change back to one monitor. Therefore I see no contraindications, to write their own applications in a way, for working on multiple monitors. Of course this is not always feasible.

19Sep/100

Check the version of Excel

In business applications very often have the functionality of the import / Export data from / do Excel. One way to retrieve data from Excel is to use OLE DB as a data provider. It's not the most optimal solution, but sometimes it is not possible to influence its choice. In order to take advantage of this method to define the connection string. And here there is a problem because in order to work this way, Excel must be installed. In addition, the definition of the connection string depends on the version of Excel installed on your computer. Both of these conditions necessitate check this before attempting to retrieve data from Excel.