Loading

Database Programming Made Easy

Submitted by: 
Visitors have accessed this post 150194 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.




Comments

sir please send your database password.
email:[email protected]

for my course, office administration.

hi. kuya?

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

thaks!

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]

programming is just like a game.Once you are used to it,it will be very difficult for you to deviate from it

How can I develop myself perfectly in programming!

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.

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

THANKYOU

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]

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

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

can u pleas help me make a data flow diagram and erd for my thesis? i'ts entitled inventory and monitoring system...thanks

i need help of u peoples me developing the project on student information system ......plz
help me ...... by mailing on ths mail "[email protected]"

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]

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]

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]

hello sir, can u send this tutorial files to my email : [email protected] .thkszz , i need for done my final project.

hello, sir/mr,
i need this tutorial ,can u email to [email protected] .

hi..

i need vb code on soduku games..can you help me..
my mail: [email protected]

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..

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]

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!

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

how to create data base in access for library management in step by step please sent in my gmail account rajeeev@gmail. com

good

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]

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

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.........[email protected]

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

pls can some body tell me how to covert image to binary and save to sql server 2005 using vb.net window form

:( 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

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

I HAVE A PROBLEM CREATING A WEB SITE REPORTS

ced's picture

use microsoftreportviewer :)

I am a student of computer science in indonesia, i hope your articel can help me to understand about DB programming wwith vb

Please help me in my project.." how to make a computerized plotting systems>>..by using a visual basic>>tnx..
My e-mail add is [email protected],

ced's picture

contact me @ [email protected]

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

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

call me @ 09267249206

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]

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

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

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

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

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

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

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]

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

Pages

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

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.
  • Lines and paragraphs break automatically.