Showing posts with label database connectivity. Show all posts
Showing posts with label database connectivity. Show all posts

Friday, October 7, 2011

Connecting a Database II

In the last edition I showed how to define a connection string. i.e. How to tell the application the type and location of said database. Here I shall detail how to use said string in the coding. Please feel free to comment on my posts with your doubts and suggestions or mail me at nardz07@gmail.com.


Saturday, October 1, 2011

Connecting a database I

Any application that needs to store or retrieve data, needs to use databases. Since we developers make the application layer, it is for us to connect the application to the database and to provide the queries to affect the data.

Here is what little insight i can provide into the databases and their connecting schema. For any suggestions or doubts, please contact me at nardz07@gmail.com.

First and foremost, databases may be operating system dependent, like MS ACCESS and SQL SERVER, or independent like ORACLE or MYSQL.


In this post, let us simply look at these databases and how to define a generic database connection using the MS Visual Studio tools.