How to generate and save Connection string in Visual Studio

Figure 3. connectionStrings in web.config

Writing connection string manually is one of the worst things in software development. That's why I always want them to be generated by any tool but not by me. Some times before I have found a way how to generate a connection string creating an .udl file in Windows ( Now I've found a better way.

(read more...)

C#. Best practice for OleDBConnection

It’s a little example, or may be template, of correct code for work with MSSQL server using OleDbConnection. There are two parts you should remember about - connection string and OleDB commands. The most difficult part of this is the connection string. It took me a lot of my time until I studied how to write this string easily. (read more...) Notes of web-specialist
Since 2009