Loading

Database Programming Made Easy

Submitted by: 
admin
Sunday, April 26, 2009 - 14:59
Visitors have accessed this post 122694 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 490 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 safrans on Fri, 12/04/2009 - 00:17

Dear Sir,

Please send me a Visual Basic 6.0 Database.
and WindowXPC Engine Learning Guide for Me.....?????

Submitted by Anonymous on Sat, 12/05/2009 - 21:55

hi. how can i do an automated time in time out system?

Submitted by Anonymous on Sun, 12/20/2009 - 22:26

hi is it possible to have a datepicker inside data grid?
if you know pls make tutorial. tnx

Submitted by Anonymous on Tue, 12/29/2009 - 09:56

select a date form datetimepicker class and add some months to that patricular date . it depends up on the day, month and year also check the leap year .

kumudsingarpu@yahoo.co.in

cedrick blas's picture

Submitted by cedrick blas on Mon, 01/11/2010 - 16:05

im creating an examination system in vb.net
i can do it in vb 6.0 to retrieve question using ADODB.RECORDSET but our instructor dont want it.. Further explain and post some code here that retrieve data in the database and post it on a label or richtextbox for the question and choices.. I think i need to use datareader but i dont know how to do it...

add:
i need also a navigation like NEXT and PREVIOUS for the question..
I did it in vb 6.0 using rs.movenext , .moveprevious.

need iT

admin's picture

Submitted by admin on Mon, 01/11/2010 - 21:03

So you want to use VB.NET?

cedrick blas's picture

Submitted by cedrick blas on Tue, 01/12/2010 - 12:21

yes sir examination system in vb.net tnx

Submitted by Anonymous on Fri, 02/05/2010 - 14:59

sir gun noon i want to make a database program that will exucute the following.
search, save, print, edit, add.
hope you can help me.

tanx a lot

Submitted by Anonymous on Sun, 11/21/2010 - 19:25

i need vb code/vb.net code for
student fees record system.
please help me.
amponsahbullet400@yahoo.com
amponsahbullet400@gmail

Submitted by Anonymous on Wed, 01/20/2010 - 11:14

gud day..sir were associate it student..We need your help in making a student record system using vb 6.0 and microsoft access for our project were rush in time.. tnx for your time to read our problem...

cedrick blas's picture

Submitted by cedrick blas on Thu, 01/21/2010 - 14:16

hi guys u can try my code... student information same with student records uve looking for =) hope u like it.

http://www.sourcecodester.com/visual-basic/student-information.html

cidfrey's picture

Submitted by cidfrey on Thu, 01/21/2010 - 14:29

Magaling si Cedrick 5 star dude @_@

Submitted by adrian09 on Wed, 07/21/2010 - 21:25

nu mgndang system para sa thesis po???

Submitted by Anonymous on Wed, 07/21/2010 - 22:58

Login System using Voice Command

Submitted by Anonymous on Thu, 07/22/2010 - 17:41

enrollment system

Submitted by Anonymous on Fri, 02/05/2010 - 12:53

hi,,im an it student can you make a library system using VB 6.0?

cidfrey's picture

Submitted by cidfrey on Sun, 02/07/2010 - 00:29

I have.

Contact me if you like 09087076539 or 09327081978

Submitted by Anonymous on Mon, 03/08/2010 - 11:27

hi i need patient recording system in a certain Health Center..
i need a source code using visual basic.. can u help me.? email us at pengie_colas@yahoo.com

Submitted by Anonymous on Thu, 02/11/2010 - 19:49

Hi, please help me, i want to come up with the on line voting system but do not know whr to strt en what to do..... please i need your _f3bwalya@yahoo.com

Submitted by Anonymous on Mon, 02/15/2010 - 11:50

morning, i am an It Student doing my final year, my project is an online hotel reservation system, is it possible to link a website and a database, so that customer bookings can be stored on the database and am using database server 2008 is it ok to use it, my email address naomymore@yahoo.com

Submitted by Anonymous on Tue, 02/23/2010 - 18:46

SQL server is very powerful database.. but mas secure ORACLE.. online hotel reservation system? ouch but online pa kasi hehehe..

"is it possible to link a website and a database"

-possible poh un hehe just imagine "FS,FB" but i think ORACLE ung gamit sa mga don..

Submitted by Anonymous on Sun, 11/21/2010 - 19:21

Please i want to develop a database and use php
to create the interface.I want to create the database to store
customer name,account details.and that of employer and employees.
Can you please help me with the code for php and mysql.
kindly send the codes to :
amponsahbullet400@yahoomail.com,
amponsahbullet400@gmail.com

Submitted by Anonymous on Wed, 03/10/2010 - 19:07

Sir admin. Im waiting for the examination System in vb.net ahmp. need it. please post some.. tnx

Submitted by Anonymous on Sun, 03/14/2010 - 15:18

thank you

Submitted by fiffe on Fri, 04/02/2010 - 08:04

Thanks a lot
It is a very good tutorial, the best I have found for databases in .net

Submitted by Anonymous on Thu, 04/29/2010 - 20:22

Sir i need ur help on this topic cos it a project am working on.
using C# or VB
my email address abbahson@yahoo.com

Submitted by Anonymous on Sun, 05/02/2010 - 19:17

im trying to make my access database to go online... is it possible can anyone share some views? please any ideas will help.... my email add is walie.majorie@gmail.com

thanks

haev

Submitted by akinyemi on Tue, 05/11/2010 - 14:02

Hello Sir,

I want to learn how to write Accounting Program either in Visual Basic 6 or Java.

I am an Accountant by profession. The purpose of my learning is that I will be able to write Accounting Program since I am an Accountant.

Accounting Program is very scarce on programming forums. Please help me.

Thank you.

Akinyemi

Submitted by Anonymous on Thu, 07/22/2010 - 19:16

You dont need to learn it cos u are an accountant.

Get BS1 Accounting software and it does all for u

Submitted by Anonymous on Thu, 05/20/2010 - 18:36

thanks

Submitted by Anonymous on Mon, 05/31/2010 - 22:16

hi..i need ur help.I want to create an inventory for storing purchasing items and update balanced automatically reminds that user need to purchase new item if the balance less than the minimum number. Can i use ur tutorial as a guideline?Do i stil need to use the microsoft access?I'm totally blur for now.
Thank you.

Submitted by Anonymous on Wed, 06/09/2010 - 04:47

I'm student of Bscs and I've to make a project on hotel reservation system in c++ .I'm making it myself but I'm not suceeding in what I want to do .If any one have this project then send it to me on my email id : umair_cs@live.com.
Admin plz help me out as soon as possible

Submitted by Anonymous on Sat, 07/03/2010 - 17:44

I want to know how I can design a program or a data base with reports on STUDENT PAYMENT SYSTEM.

Submitted by adrian09 on Wed, 07/21/2010 - 21:11

can you give me some sample system easy to defend and make????please,thanks in advance :)

Submitted by Anonymous on Fri, 07/30/2010 - 19:23

hi god day i am a beginner in creating programs can i ask your help about changing may user name and password using VB 6.0 her is may codes

Module
ublic Function isValidPassword(passwd As String, usrd As String) As Boolean
Dim rstAccount As ADODB.Recordset
Dim strSQL As String
Dim isLoggedIn As Boolean

strSQL = "SELECT [ID],[password],[User] FROM [accounts] WHERE [password]='" & passwd & "' AND [User]='" & usrd & "'"
Set rstAccount = cnnInventory1.Execute(strSQL)

If rstAccount.EOF Then
isLoggedIn = False
Else
If StrComp(passwd, rstAccount!Password, vbBinaryCompare) = 0 And StrComp(usrd, rstAccount!User, vbBinaryCompare) = 0 Then
isLoggedIn = True
Else
isLoggedIn = False
End If
End If

If isLoggedIn Then
isValidPassword = True
Else
isValidPassword = False
End If

rstAccount.Close
Set rstAccount = Nothing
End Function

My Login Codes is Ok but in the Mudel is not ok thier is an error pls..help me to solve my problem

Dim counter As Integer
Private Sub Command1_Click()
Dim rstAccount As ADODB.Recordset
Dim strSQL As String
Dim isLoggedIn As Boolean

strSQL = "SELECT [ID],[User],[Password] FROM [accounts] WHERE [Password]='" & txtPassword.Text & "'AND [User]='" & txtUser.Text & "'"
Set rstAccount = cnnInventory1.Execute(strSQL)

If txtUser.Text = "" Then
Call MsgBox("Please enter your userName and Password", vbCritical, "Blank User")
Exit Sub
Else
If txtPassword.Text = "" Then
Call MsgBox("Please enter your userName and Password", vbInformation, "Blank Password")
Exit Sub
Else
If rstAccount.EOF Then
isLoggedIn = False
Else
If StrComp(txtPassword.Text, rstAccount!Password, vbBinaryCompare) = 0 And StrComp(txtUser.Text, rstAccount!User, vbBinaryCompare) = 0 Then
isLoggedIn = True
Else
isLoggedIn = False
End If
End If
End If
End If

If isLoggedIn Then
cnnInventory1.Close
Unload Me
Call MsgBox("Welcome to my program.", vbInformation, "Authorization Successful")
' frmMain.mnuUtility.Enabled = True
'frmMain.mnuNewProd.Enabled = True

' frmSalesRecord.Command1.Enabled = True
frmMain.Show vbModal

Else
'Call MsgBox("Authorization failed.", vbExclamation, "Authorization failed.")
Call MsgBox("Error.", vbCritical, "Error.")
counter = counter + 1
txtUser.Text = ""
txtPassword.Text = ""
txtUser.SetFocus
End If

If counter > 2 Then
Unload Me
End If

End Sub

Private Sub Command2_Click()
End
End Sub

Private Sub Form_Load()
Open_Conn
End Sub

Private Sub Image1_Click(Index As Integer)
Unload Me
End Sub

Private Sub txtPassword_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
Call Command1_Click
End If
End Sub

Private Sub txtUser_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
Call Command1_Click
End If
End Sub

Submitted by Anonymous on Tue, 08/03/2010 - 20:34

good evening sir/madam can you please help me to my thesis topic. my topic is online grading system of our school. what program language that can i used in this topic? tnx

Submitted by Anonymous on Tue, 08/03/2010 - 20:38

can I use PSP FOR ONLINE GRADING SYSTEM?

Submitted by Anonymous on Sun, 08/08/2010 - 21:15

Sir,
Can you explain about each connection code. For example: what is "OleDbConnection" doing, what is OleDbadapter doing?, what is dataset doing like that. My emai id is sumesh.av@gmail.com

Submitted by Anonymous on Tue, 08/10/2010 - 20:00

hello sir ,

iam a csc student ,i need a project in hotel management using database structure.any one having this please send it to my email id- jshanmugapriya10@gmail.com.

plzzzzzzzzz send it.iam waiting for your response.please reply.

Submitted by Anonymous on Mon, 04/11/2011 - 13:29

I need hospital accounting programe

Submitted by Anonymous on Tue, 08/10/2010 - 20:00

hello sir ,

iam a csc student ,i need a project in hotel management using database structure.any one having this please send it to my email id- jshanmugapriya10@gmail.com.

plzzzzzzzzz send it.iam waiting for your response.please reply.

Submitted by Anonymous on Tue, 10/05/2010 - 17:48

Hi
Regarding Hotel Management project you can use www.planetsourcecode.com.
You will get full source of this project.

Submitted by Anonymous on Sat, 08/21/2010 - 13:40

hi! sir,
i need your help how to create on-line grading system and what better system language to apply?...please.. sent me on this Email.add magatlovelia@yahoo.com

Submitted by Anonymous on Fri, 08/27/2010 - 06:50

For 500.00 US dollars I will give you the source code for a complete system written in Visual C#, with compiled executables. Interested?

Submitted by Tomasz_Dzis on Wed, 09/01/2010 - 19:09

how to change the code TreeView Control to handle the next nodes?

Submitted by Anonymous on Thu, 09/30/2010 - 10:31

hi i am a act student ..
Can you help me in my case study about mini library system ...
using VB 6.0 and connect it into microsoft access 2003
any reply .. tnx a lot ...

Submitted by Anonymous on Tue, 11/09/2010 - 17:21

Hi,
I am a final year csc student.Please help me out.
Can anyone tell me how to connect to AIML databases using java codes.

Please mail me at maviah007@gmail.com

Please its very urgent !

Submitted by Anonymous on Sat, 12/04/2010 - 12:11

money converter system is our program we need acodes for an update delete and record new currency using php in xampp server..pls
reply

Submitted by Anonymous on Sat, 12/04/2010 - 12:12

money converter system is our program we need acodes for an update delete and record new currency using php in xampp server..pls
reply

Submitted by Anonymous on Mon, 12/13/2010 - 13:02

hi sir when i open my data base access password any one chance to find that iu open the password iam not change any data inthis data base

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.

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.