Posts Tagged ‘.Net’

Top 12 Smart Tips To Work With SQL

This item was filled under [ .Net, Design Principles ]

Your users probably don’t know a thing about SQL, but you know its value. It’s everywhere, it’s easy to learn, and SQL solutions are simple to implement. Whether you use SQL a lot or sparingly, working smarter with SQL will help you avoid errors and improve performance. Many SQLs are vendor-specific. The following tips apply [...]

Continue reading...

Tagged with: [ ]

Best Practices of ActiveX Data Object (ADO)

This item was filled under [ .Net ]

ADO – ActiveX Data Object is a library to manipulate data i.e. retrieving and storing records. Being a Microsoft library ADO offers great ease to help developers with their database queries. ADO is quite flexible and powerful as it doesn’t let the developer bother how the database is implemented. They can straightaway use the database [...]

Continue reading...

Tagged with: [ ]

FileSystemWatcher to monitor directory changes in C#

This item was filled under [ .Net ]

You must have performed certain tasks where you need to determine if the files or directories are created or even modified. One example of this is an import system that pulls flat files into a database. In this instance, a program must monitor a directory for newly created files. When a file is created, the [...]

Continue reading...

Tagged with: [ ]

Serialize hash table in C# dynamically

This item was filled under [ .Net ]

I have realized while working on a problem that .NET Framework does not allow serialization of any object that implements the IDictionary interface. I was very much disappointing with the restriction but later i figured out that the restriction is not on hash tables. There are few ways which leads people to follow the following [...]

Continue reading...

Tagged with: [ ]

11 reasons to use Access and few not to

This item was filled under [ .Net ]

The truly smart and effective IT professional knows that there are many tools. The key is to know which database engine is the best for the job at hand. Why throw massive resources at a simple need? In other words, you don’t want to pay for a Rolls Royce engine if you’re building a go-cart. [...]

Continue reading...

Tagged with: [ ]
Page 1 of 41234