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 Wed, 12/29/2010 - 13:35

sir please send your database password. email:[email protected]
Submitted byAnonymous (not verified)on Fri, 01/07/2011 - 14:00

for my course, office administration.
Submitted byAnonymous (not verified)on Fri, 01/14/2011 - 03:51

i need help... i want to know if you have a library borrowing website in PHP if you have one please send it to me for my project... email:[email protected]
Submitted byAnonymous (not verified)on Fri, 01/14/2011 - 22:25

programming is just like a game.Once you are used to it,it will be very difficult for you to deviate from it
Submitted byAnonymous (not verified)on Thu, 01/27/2011 - 18:34

How can I develop myself perfectly in programming!
Submitted byAnonymous (not verified)on Fri, 02/11/2011 - 12:09

i need a program in vb 6.0 with database using ms access... i want to create a program about hotel booking system..can u give me a source code for it?..pls.. help me pls.
Submitted byAnonymous (not verified)on Sun, 02/13/2011 - 14:20

..can anyone help me in constructing a payroll database system using ms access??.. ..please...
Submitted byAnonymous (not verified)on Tue, 02/15/2011 - 11:13

hey there, i am looking for a database which works in visual studio 2010 for entering data in access with bindingnavigation linked with the database to add delete and save the data. please can anyone send me an email to help me and i can send you my frontend to give u example. thanks caroline [email protected]
Submitted byAnonymous (not verified)on Sun, 02/20/2011 - 15:48

dear all pls give any answer and solve my problem for oracle dba database front hand vb 6.0 i have create form and stablished unique constant 2 alphabates 5 number 1 special character like AW-00025 SO ON NOT RECORD DOUBLE [email protected] [email protected] REGARDS TAHIR
Submitted byAnonymous (not verified)on Tue, 02/22/2011 - 09:17

sir plzzzzzzzzzz help me for my system cashering system mmmmm thankzz...
Submitted byAnonymous (not verified)on Sun, 03/13/2011 - 08:58

can u pleas help me make a data flow diagram and erd for my thesis? i'ts entitled inventory and monitoring system...thanks
Submitted byAnonymous (not verified)on Wed, 03/16/2011 - 05:25

i need help of u peoples me developing the project on student information system ......plz help me ...... by mailing on ths mail "[email protected]"
Submitted byAnonymous (not verified)on Sun, 03/20/2011 - 12:54

sir/maam, can u send me of ur code of hotel reservation system...please help me sir/maam..on tuesday we have my defend of that but my work are not finish...please send to my email [email protected]
Submitted byAnonymous (not verified)on Tue, 03/22/2011 - 12:41

please can you help me by giving the project of online shopping with asp.net and c#code and sql server 2005 as back end please....... i am studying in final year bca in ncb my main id is [email protected]
Submitted byAnonymous (not verified)on Sat, 03/26/2011 - 23:51

Hello I need to know how can I upload Sql Database on server.If it is by scripting than how to Do it? Please can you help me. Contact me at [email protected]
Submitted byAnonymous (not verified)on Sun, 03/27/2011 - 12:04

hello sir, can u send this tutorial files to my email : [email protected] .thkszz , i need for done my final project.
Submitted byAnonymous (not verified)on Sun, 03/27/2011 - 16:01

hi.. i need vb code on soduku games..can you help me.. my mail: [email protected]
Submitted byAnonymous (not verified)on Mon, 04/04/2011 - 22:08

sir/maam.. Im acomp[uter programming student i just want to ask, how can i make my string password into a character using Java language? pls help me... Send me ur answer in this email: [email protected].. thanks..
Submitted byAnonymous (not verified)on Fri, 04/15/2011 - 05:45

Hi - in need of a simple vb menu driven application, Patients, Appointment and Treatment, backend access to store the information, and for VB to Add, Delete, Edit and Search records. Thanks please send to [email protected]
Submitted byAnonymous (not verified)on Sat, 04/16/2011 - 03:07

Hello sir. Thanks to your good and useful programs. I need your help. Please source or if you have a project or program Who can help me do a project to build the language Visual Basic 6 projects for myself that I could just do serial code Find and install software serial code is needed. Thanks!
Submitted byAnonymous (not verified)on Sun, 04/17/2011 - 00:21

i am supposed to do a pre fianl year project in computer graphics.... i m a newbie n i dnt knw anythng abt opengl.. i request to help me with tis.... my project topic is balancing the ball on seesaw.... plzzz do help me.....its a humble request
Submitted byAnonymous (not verified)on Tue, 05/03/2011 - 18:43

how to create data base in access for library management in step by step please sent in my gmail account rajeeev@gmail. com
Submitted byAnonymous (not verified)on Sat, 05/07/2011 - 15:52

HELO SIR; HOW TO CREAT IN DATABASE THE SCHOOL SYSTEM . I REALY WANT THIS SO PLZ SND ME FULL SCHOOL SYSTEM PLZ SND MY EMAIL [email protected]
Submitted byAnonymous (not verified)on Thu, 05/12/2011 - 19:24

i need a project for billing system which can display the output in PDF format and when i click any items it should be come form database
Submitted byAnonymous (not verified)on Sun, 05/15/2011 - 00:46

I started a small freight, logistics business about a year ago doing everything from local home deliveries to driving clear across the country. Iv grown so fast I cant keep up with pen and paper anymore. We are so unorganized that some invoices aren't even getting billed. Unfortunately, I dont have any time to school myself amongst the chaos, and my cash flow is so screwed up I seem to never have money to pay someone for me. Anyways, I need a inventory/ warehousing/ management program. Then some how relay that info to my web page I had someone build for me. I need order if im to succeed! Im at your mercy, plz help me before I explode. Thank you email [email protected]
Submitted byAnonymous (not verified)on Sun, 05/15/2011 - 20:21

i like his articles, , good job bro :) thanks
Submitted byAnonymous (not verified)on Sun, 05/22/2011 - 20:18

pls can some body tell me how to covert image to binary and save to sql server 2005 using vb.net window form
Submitted byAnonymous (not verified)on Fri, 06/24/2011 - 23:26

:( who can help me in cai using vb coz i ned to do a program like math tutorial for kids. who can give me a codes? pls help me :(. here is my e add at [email protected] thankx in advance for those who can help me god bless
Submitted byAnonymous (not verified)on Tue, 09/13/2011 - 22:11

I am a student of computer science in indonesia, i hope your articel can help me to understand about DB programming wwith vb
Submitted byAnonymous (not verified)on Fri, 09/30/2011 - 15:19

Hi there I need a system similar to the one found on milkroundsoftware.co.uk. It just doesn't fulfil my full requirements. I have a very basic knowledge of visual basic and i could probably add to the program myself but its setting it up like the software on that website i would strugle with. If anyone can help i can be reached at [email protected] Kind Regards Martyn
Submitted byAnonymous (not verified)on Tue, 10/04/2011 - 14:44

can you help me how to make barangay system??? ..
Submitted byAnonymous (not verified)on Thu, 11/24/2011 - 19:52

hello sir;i need a c progra code that can be used to collect toll fees.pliz pliz help. u can sent it to my email id [email protected]
Submitted byAnonymous (not verified)on Fri, 12/09/2011 - 15:14

hello everyone.. i am a 1st yr student and i have a problem with regards to inserting a record OR ADDING A NEW USER to an MS Access database... i am using vb.net.. please help me guys... thank you.. my codes are as simple as this: butttonAdd_click(..........) connect() dim Command as new OledbCommand(" insert into LogIn (Id,UserName, Password) Values ('" & txt.Id.text & "', '" & txtUserName.text & "', '" & txtPassword.text & "')", con) cmd.ExecuteNonQuery msgBox("Successfully Add New Record") disconnect() End Sub ----> this one is not actually working
Submitted byseng (not verified)on Fri, 12/30/2011 - 00:50

how to make data base connection with access to vb.net
Submitted bykenneth malabanan (not verified)on Thu, 02/02/2012 - 00:18

i just want to ask about captcha for our thesis, is it possible to include the function keys in captcha? i hope you could answer me as soon as possible
Submitted byMichel.net (not verified)on Fri, 03/02/2012 - 08:25

I want to just thank you for your tutorial. It's almost unbelievable you find the time to write such an extensive tutorial and manage to answer all the "dear sir, please can you help me" posters here. I am re-entering the world of programming. It's almost 15 years ago and a lot has changed (for the better) since then. I am sure your database tutorial will prove to be very helpfull indeed. Again, thanks. Regards, Michel
Submitted byAnonymous (not verified)on Wed, 03/07/2012 - 01:45

Hi Sir,

Im a real newbie (a kid ) and have very low knowledge of this subject , But I really need to learn this because this is what i like, I hope you will help me please

Thank you

[email protected]

Submitted byMsemo Iddi (not verified)on Tue, 05/08/2012 - 12:39

9c article admin can i get code for backup data which are lost in database

Add new comment