Database Programming Made Easy

Submitted by admin on Sunday, April 26, 2009 - 14:59.

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

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

Comments

I Want to Learn Database

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

hi. how can i do an automated

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

datepicker in datagrid

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

using c#.net workin date class

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

admin i need your help =)

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

re: admin i need your help =)

So you want to use VB.NET?

re re re admin

yes sir examination system in vb.net tnx

sir i need your help

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

yes

i need vb code/vb.net code for student fees record system. please help me. [email protected] amponsahbullet400@gmail

hi..

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

student records

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

Magaling si Cedrick 5 star

Magaling si Cedrick 5 star dude @_@

kuya patulong..ehe

nu mgndang system para sa thesis po???

Here

thesis subject

enrollment system

library system

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

Me

I have. Contact me if you like 09087076539 or 09327081978

hi

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

Hi, please help me, i want to

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

online hotel reservation system

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

re

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

help me

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

cedrick blas here

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

hi

thank you

Database Programming Made Easy

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

Medical laboratory management system

Sir i need ur help on this topic cos it a project am working on. using C# or VB my email address [email protected]

can anyone help me on this

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

Accounting Program in Visual Basic 6/Java

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

You dont need to learn it cos

You dont need to learn it cos u are an accountant. Get BS1 Accounting software and it does all for u

thanks

inventory database

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.

Plz help me urgently

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 : [email protected]. Admin plz help me out as soon as possible

help me out as soon as possible

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

hi sir..gudeve!

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

operation is not allowed when the object is close

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

Add new comment

Add new comment
1997 views