Database Programming Made Easy

In this tutorial I will discuss to you on how you can access the database easily. I came across this idea because this is also my problem when I started working with database programming.

I hope that in one way or another I can help you in your journey to the world of programming. Programming is fun and easy if you just simply devout your time with it. I cannot stress enough how easy programming is if you only read an online tutorial like this.

Take It Easy

Just don’t be rush in learning programming. Take it easy and study everyday. Don’t start right away thinking that you can create a system like payroll, accounting, hotel reservation, point of sale without even having a single knowledge about database programming.

Learning by Doing

Learning by doing is the next thing. You need to practice what you learn. In this tutorial I encourage you to take the sample code into practice.

I will list below the content that I am going to discuss. This is a series of tutorial so be sure to visit the site regularly or subscribe to my Feeds at the right side bar.

I will arrange the topic according to their importance, that is, what to do first before you jump ahead to the next topic. Along the way, I will add a topic before or after other topic or whatever that will come to my mind that I know a must have tutorial.

Table of Contents

  1. Making Database Connection
  2. How to Retrieve Data
    1. Using Data Reader
    2. Using Datasets and Data Adapters
  3. How to Modify Data
    1. Using ExecuteNonQuery
    2. Using Datasets and Data Adapters
  4. Windows Forms
    1. How to Retrieve and Save Data using TextBox Control
      1. Using Data Readers and ExecuteNonQuery
      2. Using Datasets and Data Adapters
    2. ComboBox Control
    3. ListView Control
    4. DataGridView Control
    5. CheckBox Control
    6. TreeView Control
  5. How to Print Using Crystal Reports

If you’d like to suggest a topic, don’t hesitate to write a comment below.

Comments

Submitted byAnonymous (not verified)on Fri, 05/08/2009 - 15:42

Hi, i noticed that part 4 of your article was nowhere to be found
Submitted byadminon Fri, 05/08/2009 - 17:00

In reply to by Anonymous (not verified)

I'm working on it. This is the important part of the tutorial. Since it requires and actual manipulation of data using common controls like text box.
Submitted byAnonymous (not verified)on Tue, 05/26/2009 - 12:26

hi, i'm a newbie vb.net programmer. would just like to ask, how to use multi database in a program. and have them integrating with one another. thanks!
Submitted byadminon Wed, 06/03/2009 - 11:49

In reply to by Anonymous (not verified)

May be you mean how to connect multiple workstation in just one database?
Submitted byAnonymous (not verified)on Tue, 05/26/2009 - 13:58

Wonder if you could include a tutorial on manipulating data through the tree view.
Submitted byAnonymous (not verified)on Thu, 06/04/2009 - 14:00

In reply to by admin

Hi, Good day. I saw your staff and your good. Im asking and at the same time I need your help to creat a simple enrollment system for my school. Please contact me via SMS, here's my # 09156913989. Thanks.
Submitted byAnonymous (not verified)on Tue, 06/09/2009 - 13:22

sir sana make din u toturial display ng record sa datagrid and listview......
Submitted byadminon Wed, 06/10/2009 - 13:01

In reply to by Anonymous (not verified)

Actually it was already included in some of my program like hotel and enrollment system. But wait until I finish some control in this tutorial.
Submitted byAnonymous (not verified)on Thu, 06/25/2009 - 15:47

hi pls help me for our project,,were making a system using visual basic 6.0....plzz!just cnd me email f u help me [email protected],,im w8ng..tanx..
Submitted byadminon Thu, 06/25/2009 - 17:24

In reply to by Anonymous (not verified)

Not a very nice request. Send me email of what your asking rather than waiting for my email. LOLs...
Submitted byAnonymous (not verified)on Fri, 06/26/2009 - 17:06

In reply to by Anonymous (not verified)

just post the project you wanted... :P
Submitted byAnonymous (not verified)on Fri, 06/26/2009 - 17:00

sir on the making na ba yung tutorial for datagrid? :).....
Submitted byadminon Fri, 06/26/2009 - 17:42

In reply to by Anonymous (not verified)

I will start working again on my database tutorial tomorrow. I'm so kinda busy with hotel reservation system (vb.net) right now. Comeback tomorrow...
Submitted byAnonymous (not verified)on Mon, 06/29/2009 - 22:18

prominent ! i need your help.
Submitted byAnonymous (not verified)on Fri, 07/03/2009 - 05:58

Hi Sir, I've a simple html site..with 20 pages... I would like to create internal site search... Can you pls guide me....I've done this with ASP.NET but in that case website was Database Driven...I dont know how can i achieve it in simple html case... Help would be appreciated.. [email protected]
Submitted byAnonymous (not verified)on Fri, 07/10/2009 - 16:28

Hi Sir, Do you have sample program that uses hardware device like barcode reader, Finger print reader runs in VB.Net. I am planning to develop this kind of program.. Please share your experties.. Pls. contact to my email add: [email protected] Thanks.. Mike

I have but I can't give it for free because I bought the SDK to develop this program. It will be out may be next week for a fair price.
Submitted byAnonymous (not verified)on Wed, 07/15/2009 - 01:41

Good Day Sir, here's my problem.. uhmm iam in my 4th year now and our dean required us to develop a database program which is we choose a record keeping database for cooperative. uhmm sir-- right now iam using visual basic 6. and iam having a hard time how will i make an output for print in VB6, they said it is cystal report, but i have no idea how to work on it. Sir i really need your help, can u give me a lil bit of video tut. -- i knw its to much but please do help me. heres my e-add [email protected].
Submitted byAnonymous (not verified)on Wed, 07/15/2009 - 18:08

Dear sir, Can I use BMC INternational Fisical Printer, Customer display and Emobile connected to the COM port to print receipts? Can U help me sending the code this serial printer? Many thanks
Submitted byAnonymous (not verified)on Mon, 08/03/2009 - 17:02

i am student of bscs . where having out thesis, where decided to make a payroll system . i am using Visual Basic 2008 express edition can you help me ..dis s my email add [email protected]
Submitted byAnonymous (not verified)on Wed, 08/19/2009 - 22:49

Hi, I am a newbee in programming. Hope you experts can give some directions. Thank you and appreciate in advance for your help. I am designing a ASP.net web application on Visual Studio 2008 Professional Edition using VB language. This is what I have: 1. I have a few text boxes on my web form where user can fill in the asked information 2. There is also a button named "Submit" on the web form 2. I also have a seperate file (.mdb) created on MS Access 2003 containing a data table with some columns like name, age, address etc. This is what I want to do: After the user fills all the information in the textboxes in the web form and clicks the submit button, the information from textboxes should get stored into the in MS Access table in chronological order without deleting any previous information already stored on the table. [There should be a way which can define that information from a particular textbox should go to a particular column in the MS Access table (this is what I think)] Dear all, I am not good in writing code and a new programmer. I will be very thankfull if somebody can walk me through to complete this task with minimal code. Thank you all once again. DG
Submitted byAnonymous (not verified)on Thu, 09/10/2009 - 01:13

Hello sir, Am to come up with a database for orphans and vulnerable children and though of sharing with you since you could have a sample Project. My address is [email protected]
Submitted byAnonymous (not verified)on Thu, 09/10/2009 - 12:49

Sir, please help me to know about the role based security in my webpage.im giving user rigths to my project.... im using c#. according to the role, page can be accessed how to do..... im not using webconfig file......just from database .
Submitted byAnonymous (not verified)on Thu, 09/24/2009 - 17:59

Hi.. About your "Database Programming Made Easy" tutorial. I think there's a problem with the link in "ListView Control", it directs to a different topic. tnx!
Submitted byadminon Tue, 09/29/2009 - 09:00

In reply to by Anonymous (not verified)

No. It is a correct link. Please follow the tutorial and download the code. You will find listview control there.
Submitted byAnonymous (not verified)on Fri, 10/02/2009 - 10:47

In reply to by admin

sir im a act student, can u share ur idea about library system for my project. my id [email protected] thank you so much.
Submitted byAnonymous (not verified)on Thu, 11/19/2009 - 11:15

In reply to by admin

can you give me some example of enrollment system? using Visual BAsic?,.... Tnx... COMVIT student ....
Submitted byAnonymous (not verified)on Sun, 10/11/2009 - 05:08

i am a student. i like very much to learn vb, and i think of u like my master becouse i had learn so much from u. i thought if u can send mi in rar file this series of tutorial with the data source that u had create, and every thing else where i can learn become a professionist like u. i would be gratefull. Any way thanks for every thing.my email : [email protected]
Submitted byAnonymous (not verified)on Thu, 10/15/2009 - 05:07

can u create a tutorial for DataRereater control
Submitted byAnonymous (not verified)on Thu, 10/15/2009 - 23:44

YES
Submitted byAnonymous (not verified)on Mon, 10/19/2009 - 14:33

sample code in making a snake and ladder boardgame
Submitted byAnonymous (not verified)on Fri, 11/13/2009 - 15:44

hi good day admin....can i request udf that i can use for converting number into words.

Add new comment