Things to remember before creating a vb.net database-oriented program

In this guide, I will share to you the things that I usually do when I create a vb.net application which connects to a database.

 

Creating a class

First thing that you need to remember is to create classes. This is useful for any kind of program that you’re creating since it will make your code more organized. It will separate the interface from the program logic. So that the code for the database manipulation(create, retrieve, update, and delete queries) and the code for the events and program interface (the part of the program which people see) will be separated from each other. And it will be easier for the programmer if the code is written this way. And there’s a plus point on this since vb.net is an object-oriented programming language.

Just visit this site for more information about the importance of classes.

 

Basics

As they say, we need to always start with the basics. Do a little bit of vb.net programming basics first before you proceed in making your very first database-oriented program. Because there are things that you might not understand which are included in creating a database-oriented program. You need to learn first about:

  • Loops
  • If statements
  • Try-catch
  • Msgbox
  • Visual Studio Interface
  • Classes
  • Subs and functions

And after you learned all that, it will now be easier for you to create a database-oriented program.

 

Visit ConnectionStrings.com

The site with the largest collection of connection strings for databases that I know about. Here’s the link. This site is really useful if you don’t feel like memorizing every connection string for every database that you know.

 

Use ODBC

As much as possible, try to use ODBC when trying to connect your vb.net application to a database. As it will make your life easier. You can manage what database to connect to using a GUI which is installed in your Operating System when you install the ODBC driver for a certain type of database.

 

Conclusion

That’s’ pretty much all you have to remember when connecting to a database. Please share it to others if you find this article useful, thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s