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.

I have a "secret" knowledge how easily write the text of connection string and even to try it. This post is for registered users only (http://markimarta.com/c/how-easily-write-the-text-of-connection-string/).

Below is the part of C# code to work with OleDbCommand: