Loading

Database Programming Made Easy

Submitted by: 
admin
Sunday, April 26, 2009 - 14:59
Visitors have accessed this post 120244 times.


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.



Tags: 
vb.net
database
tutorial
dataset
dataadapter
data reader
admin's picture

Article by admin

admin has submitted 489 source code / articles.

If you like this post, you can follow SourceCodester on Twitter.

Subscribe to SourceCodester feed via RSS or EMAIL to receive instant updates.

Comments

Submitted by Anonymous on Wed, 12/29/2010 - 13:35

sir please send your database password.
email:sajibbiswas.ma@yahoo.com

Submitted by Anonymous on Fri, 01/07/2011 - 14:00

for my course, office administration.

Submitted by Anonymous on Sat, 01/08/2011 - 14:24

hi. kuya?

Can you help us how to browse and upload a picture?

thaks!

Submitted by Anonymous 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:abutata519@yahoo.com

Submitted by Anonymous 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 by Anonymous on Thu, 01/27/2011 - 18:34

How can I develop myself perfectly in programming!

Submitted by Anonymous 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 by Anonymous on Sun, 02/13/2011 - 14:20

..can anyone help me in constructing a payroll database system using ms access??..
..please...

Submitted by Anonymous on Sat, 02/26/2011 - 21:59

THANKYOU

Submitted by Anonymous 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

carolinet@windowslive.com

Submitted by Anonymous 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
tahirjavaid@cyber.net.pk
imtjb786@gmail.com

REGARDS
TAHIR

Submitted by Anonymous on Tue, 02/22/2011 - 09:17

sir plzzzzzzzzzz help me for my system cashering system mmmmm thankzz...

Submitted by Anonymous 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 by Anonymous 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 "shaimalik125@gmail.com"

Submitted by Anonymous 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 dcaironesa@yahoo.com

Submitted by Anonymous 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 vasanthipy@gmail.com

Submitted by Anonymous 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 arc@solapurpoint.com

Submitted by Anonymous on Sun, 03/27/2011 - 12:04

hello sir, can u send this tutorial files to my email : chenkahkeat@yahoo.com .thkszz , i need for done my final project.

Submitted by Anonymous on Sun, 03/27/2011 - 12:12

hello, sir/mr,
i need this tutorial ,can u email to chenkahkeat@yahoo.com .

Submitted by Anonymous on Sun, 03/27/2011 - 16:01

hi..

i need vb code on soduku games..can you help me..
my mail: m_jingle@yahoo.com

Submitted by Anonymous 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: Oancute_17@yahoo.com..
thanks..

Submitted by Anonymous 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 neilpaton79@yahoo.co.uk

Submitted by Anonymous 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 by Anonymous 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 by Anonymous 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 by Anonymous on Fri, 05/20/2011 - 21:44

good

Submitted by Anonymous 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 SILENT_DECODE@YAHOO.COM

Submitted by Anonymous 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 by Anonymous 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 is.........ryga29@yahoo.com

Submitted by Anonymous on Sun, 05/15/2011 - 20:21

i like his articles, , good job bro :) thanks

Submitted by Anonymous 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 by Anonymous 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 sesamee_street@yahoo.com thankx in advance for those who can help me god bless

Submitted by Anonymous on Wed, 07/27/2011 - 12:58

Dear Sir i wanna to create a system in java that support voice password system , plz give me some code

Submitted by Anonymous on Mon, 08/22/2011 - 13:46

I HAVE A PROBLEM CREATING A WEB SITE REPORTS

cedrick blas's picture

Submitted by cedrick blas on Sun, 08/28/2011 - 22:56

use microsoftreportviewer :)

Submitted by Anonymous 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 by Anonymous on Sun, 09/25/2011 - 12:50

Please help me in my project.." how to make a computerized plotting systems>>..by using a visual basic>>tnx..
My e-mail add is jearald_21@yahoo.com,

cedrick blas's picture

Submitted by cedrick blas on Sun, 09/25/2011 - 21:18

contact me @ cedrickblas@yahoo.com

Submitted by Anonymous 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 lsgrampian@gmail.com

Kind Regards

Martyn

Submitted by Anonymous on Tue, 10/04/2011 - 14:44

can you help me how to make barangay system???
..

Submitted by Anonymous on Tue, 12/27/2011 - 09:18

call me @ 09267249206

Submitted by Anonymous 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 ernestmabvuu11@gmail.com

Submitted by Anonymous 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 by Anonymous on Fri, 12/30/2011 - 00:50

how to make data base connection with access to vb.net

Submitted by Anonymous 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 by Anonymous 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 by Anonymous on Fri, 03/02/2012 - 18:34

Hi again,

As I was browsing your tutorial I found out that the "Listview Control" hyperlink is pointing to the wrong page.

Greetings,

Michel

admin's picture

Submitted by admin on Fri, 03/02/2012 - 21:02

Thank you very much for reporting this error. We are now looking for the correct path to this tutorial.

Submitted by Anonymous 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

reyan.perumal@gmail.com

Submitted by Anonymous on Tue, 05/08/2012 - 12:39

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

Pages

Add new comment

More information about text formats

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.