Loading

Database Programming Made Easy

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

Hi, i noticed that part 4 of your article was nowhere to be found

admin's picture

I'm working on it. This is the important part of the tutorial. Since it requires and actual manipulation of data using common controls like text box.

hi,

i'm a newbie vb.net programmer. would just like to ask, how to use multi database in a program. and have them integrating with one another.

thanks!

admin's picture

May be you mean how to connect multiple workstation in just one database?

Wonder if you could include a tutorial on manipulating data through the tree view.

admin's picture

Okay. No problem.

Hi, Good day. I saw your staff and your good. Im asking and at the same time I need your help to creat a simple enrollment system for my school. Please contact me via SMS, here's my # 09156913989. Thanks.

admin's picture

Please email me using the Contact page.

Dear Sir,
I need your help thanks

ITM

sir sana make din u toturial display ng record sa datagrid and listview......

admin's picture

Actually it was already included in some of my program like hotel and enrollment system. But wait until I finish some control in this tutorial.

ok i will w8..

hi pls help me for our project,,were making a system using visual basic 6.0....plzz!just cnd me email f u help me [email protected],,im w8ng..tanx..

admin's picture

Not a very nice request. Send me email of what your asking rather than waiting for my email. LOLs...

just post the project you wanted... :P

sir on the making na ba yung tutorial for datagrid? :).....

admin's picture

I will start working again on my database tutorial tomorrow. I'm so kinda busy with hotel reservation system (vb.net) right now.

Comeback tomorrow...

prominent !
i need your help.

Hi Sir,
I've a simple html site..with 20 pages...
I would like to create internal site search...
Can you pls guide me....I've done this with ASP.NET but in that case website was Database Driven...I dont know how can i achieve it in simple html case...

Help would be appreciated..
[email protected]

admin's picture

A bit confusing...You have an HTML site with database driven? Unless you use the mod rewrite.

Hi Sir,

Do you have sample program that uses hardware device like barcode reader, Finger print reader runs in VB.Net. I am planning to develop this kind of program.. Please share your experties..

Pls. contact to my email add: [email protected]

Thanks..

Mike

admin's picture

I have but I can't give it for free because I bought the SDK to develop this program.

It will be out may be next week for a fair price.

. , + im a programer i want to create a enrollment system, can you help me.???

plzzzz...

. , + here my email add [email protected]

admin's picture

Download my source code at the right side bar. It's under Popular block.

Good Day Sir, here's my problem.. uhmm iam in my 4th year now and our dean required us to develop a database program which is we choose a record keeping database for cooperative. uhmm sir-- right now iam using visual basic 6. and iam having a hard time how will i make an output for print in VB6, they said it is cystal report, but i have no idea how to work on it. Sir i really need your help, can u give me a lil bit of video tut. -- i knw its to much but please do help me.
heres my e-add [email protected]

admin's picture

There's a lot of sample about crystal reports here. Download and study it

Dear sir,
Can I use BMC INternational Fisical Printer, Customer display and Emobile connected to the COM port to print receipts? Can U help me sending the code this serial printer?
Many thanks

i am student of bscs . where having out thesis, where decided to make a payroll system . i am using Visual Basic 2008 express edition can you help me ..dis s my email add [email protected]

admin's picture

You can download my payroll system. It is made in VB.NET 2008.

i have a problem with my theses

http://www.microsoft.com/visualstudio/en-us/products/2010/default.mspx

Hi,

I am a newbee in programming. Hope you experts can give some directions. Thank you and appreciate in advance for your help.

I am designing a ASP.net web application on Visual Studio 2008 Professional Edition using VB language.

This is what I have:
1. I have a few text boxes on my web form where user can fill in the asked information
2. There is also a button named "Submit" on the web form
2. I also have a seperate file (.mdb) created on MS Access 2003 containing a data table with some columns like name, age, address etc.

This is what I want to do:
After the user fills all the information in the textboxes in the web form and clicks the submit button, the information from textboxes should get stored into the in MS Access table in chronological order without deleting any previous information already stored on the table.

[There should be a way which can define that information from a particular textbox should go to a particular column in the MS Access table (this is what I think)]

Dear all, I am not good in writing code and a new programmer. I will be very thankfull if somebody can walk me through to complete this task with minimal code.

Thank you all once again.

DG

admin's picture

I hope somebody can help you since I don't have time on this yet.

Hello sir,
Am to come up with a database for orphans and vulnerable children and though of sharing with you since you could have a sample Project.

My address is [email protected]

hellow sir

I need your help i am to create a database managing destitutes for my final project at school so i need help, incase u have a sample project.my email address is [email protected]

Sir,

please help me to know about the role based security in my webpage.im giving user rigths to my project.... im using c#. according to the role, page can be accessed how to do..... im not using webconfig file......just from database .

Hi.. About your "Database Programming Made Easy" tutorial. I think there's a problem with the link in "ListView Control", it directs to a different topic.

tnx!

admin's picture

No. It is a correct link. Please follow the tutorial and download the code. You will find listview control there.

sir im a act student, can u share ur idea about library system for my project. my id [email protected]
thank you so much.

can you give me some example of enrollment system? using Visual BAsic?,.... Tnx...
COMVIT student
....

i am a student. i like very much to learn vb, and i think of u like my master becouse i had learn so much from u. i thought if u can send mi in rar file this series of tutorial with the data source that u had create, and every thing else where i can learn become a professionist like u. i would be gratefull.
Any way thanks for every thing.my email : [email protected]

admin's picture

I will create a pdf on this. So please wait until I finish it.

can u show me how to passing variable from a form to another.

admin's picture

Wait I will create a tutorial for this. It will be on the front page after I upload it.

can u create a tutorial for DataRereater control

admin's picture

Do you mean DataRepeater?

YES

sample code in making a snake and ladder boardgame

plz; i am having problem with using my visual basic.net inteface to access a microsoft access database; plz i need ur help urgently;
here is my email. [email protected]
nicholas.

hi good day admin....can i request udf that i can use for converting number into words.

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.