Database Guide
Level:
This Visual Basic 6 guide walks you step by step through VB6 tutorials and VB6 source code on this site that will help you learn how to develop applications that store and retrieve data from database back ends. As you read each of these database tutorials you will gain more and more knowledge in how to handle databases in your VB apps. The best way to navigate through the guide is by using the links on the left. Or you can use the links below and then hit your browser's back button. Each link will take you to a different vb6 database tutorial on this site that will teach you the next step you need in order to become a VB6 database guru.
- To do anything of value in Visual Basic related to databases you will first need to learn how to write SQL statements to extract what you want from your back end database. This applies to not only Microsoft SQL server but also to Access and Oracle databases. Learn how with this Introduction to SQL (Structured Query Language)
- The data control in VB6 allows you to interact with your backend database with out having to write all the code by hand. This is great when you are first learning how to do database development in Visual Basic or for quick and simple VB6 database applications. For more complicated applications you will probably use ADO. Still check out this Database Access with the VB6 Data Control tutorial to start getting your feet wet.
- This tutorial is optional as DAO is a somewhat older way of Visual Basic database development. However, if you ever have to interact with older code its good to at least understand the basics of this. Check out the Using DAO (Data Access Objects) Code Tutorial
- Again, RDO is still not the newest (and best) way to access back end data. However, there is a lot of VB database code out there that uses RDO so its probably good to at least glance through this tutorial in order to know what to do if you ever work on and VB RDO project. Database Access with RDO (Remote Data Objects) in VB6
- This is a must read! Visual Basic ADO development is the newest (and best) way to interact with any database. After walking through this tutorial you should be able to have every tool in your belt to grab data, modify it, and write back to any database you come in contact with. Any VB6 database developer must read this Database Access With ADO in VB6 tutorial
- Once you understand all the basics of how to use ADO to work with a database you will probably want to display that data to your end user in some way. One very effective way of doing this is with the list view that is built into the VB6 IDE. Using ADO and the ListView control in VB6
- It is bad programming practices to write all your SQL statments directly into your Visual Basic source code. This makes it hard to change things down the road and also has a performance disadvantage compared to using stored procedures. Learn how all this works in this tutorial: Using ADO and stored procedures in VB6
- If you ever need to print of reports for end users you might want to consider using Crystal Reports. Although many times you can get away with writing your own reports or exporting things to Excel or Word at times this isn't an option. Check out this Using Crystal Reports with VB6 tutorial to learn more about how to create these for your end users.
- Optional: This is optional because unless you are having to interact with an Oracle database you will never need to know this information. However if there is a time you need to use Visual Basic and Oracle together I recommend you check out this
help me for my project
i m doing project of dairy production management
but i don't know how to make it
if you have any project related this then pl send me
or guide me how to make my project
i m doing this project using simple vb 6.0 components
how to save data to sql 2005 specific table with vb6
i am completely new to programming, anyway, i created a form with text boxes and datagrid that users can input data. i have also created a database with 3 tables. now i want to make a save button that data can store in the correct table, how can i do this? i have managed to connect to the db with ADODB coding. thanks in advance.
saving data to a database
hi i urgently need your help. i have created a video library management system and i've connected to the DB but i don know the code on how to save new entries to the database. one of the forms have an optbox to display whether male or female. and also how to search for a record from a DB by inputting either the client name or the client id. pliiiiiz help urgently.
Private Sub
Private Sub cmdUpdate_Click()
data1.UpdateRecord `write controls to dynaset
End Sub
All you have to do is update the recordset using update Method. Your opt box in the database has to be yes or no type. See MSDN Library for more info.
search engine source code
can some1 tell me how to do the code for a search engine about student according gender,programme they taking,their hostel,etc..how do i do the codes by using vb6 anyway?
someone pls email to me xenolim@hotmail.com because thats my assignment and i cant find any tutorial about a search engine so far..
and i reali duno wat to do anymore..with other SW.
if anyone know wat to do
pls email the guild to me aSaP thz...
How to write codes for a search button.Posted By OLURIN ADEYINKA
i need the coding for the search button in my application.When using Access database as your database.with ADOData control (ADODC)
KINDLY MAIL ME ON: olurinadeyinka@yahoo.com
How to write codes for a search button. By OLURIN ADEYINKA
i need the coding for the search button in my application.When using Access database as your database.with ADOData control (ADODC)
KINDLY MAIL ME ON: olurinadeyinka@yahoo.com
Listview using ADODC
i have a problem on how to use the listview in visual basic to view the record using the ADODC connection to MS access..
sir.. i really.. really.. need the code for that to finish my system.. just e mail me the complete code..
Thank you very much...
adodc
About your question? Use data grid to make it easy. Then data grid set properties to data source and select your adodc..tnx
Hii
hello everyone am from Kurdistan-hawler. I wanna know how can I connect the vb projects with asp or other servers for site desigings
Mail Me Now...........
What ever the question regardin vb6 your solution is just a mail away...
exchange code with me
raom_1984@rediffmail.com
image recognitation.....
Respected sir,
i am a engg college student. we are doing image recognition project in vb.we need source code for this project
thanking you
how to connect ms access2007 to vb6.0
how to connect ms access2007 to vb6.0
use datacontrol component
you can connect vb6 to
you can connect vb6 to access 2007 by simply following the steps in connecting vb6 to access 2003. that's it.
database connection with access 2007
thnx
Mail Me Now...........
What ever the question regardin vb6 your solution is just a mail away...
vb 6 list view with ms SQL
Can you expound on this vb6 database tutorial - I am trying to show my items in a table in ms SQL , to a list view how best can do it my table has 40 fields
pls help me
giv me programs 4 scientific calculator.......traffic signal using timer control
database problem
Hello, i was just wondering if you can help me on my project
I have created a database with 2 tables
1st table-original
2nd table-generated
How do i connect that database to VB. In my VB form, there will be 2 label for input purposes that will serve as input for those tables in dbase.
In other words, everthing that users type on the VB form will be transfered into DB. Thank you. Your help is very much appreciated
help help
sir i have to make a vb project of airline reservation in vb6. and i m not able to complete that project. becoz the coding is so tough.do you have any reservation project with full coding. if yes, then pppppppppllllllllssssssss send me sir on my email id
Connecting two different sql databases in vb6
Hi Im Shini,
I want da vb6 coding for how to connect 2 different sql databases in one program
plz sent me a coding , Thanks
comparing two tables
i'm using access database, i want how to connect dynamically to database and i have two 2 tables in database i want to compare 2 table from one database and put the selected recorded in dbgrid.
2.i want to compare 2 table from one database and put the selected recorded datarepoprts
pls send me complete code
>database connction
i have a problem on how to connect database to msgbox.... in visual basic programming
how to connect database to msgbox
just use string and manipute it in msgbox .. i mean string manipution... that it..
example
dim strId, strName, strAddress as string
call opendbcon
rs.opendatabase "select * from tbluser ", db, opendynamic, adoptimistic
do while not rs.eof
strId = rs("Id")
strName = rs("Name")
strAddress = rs("Address")
msgbox "Id:" & " " & strId & vbcrlf & "Name:" & " " & strName & vbcrlf & "Address" & " " & strAddress, vbinformation, "Title: My User "
rs.movenext
loop
rs.close
db.close
exit sub
waht?
what is you reason? why you want to connect msgbox to the database?for what reason?
--kiluah24--
Accessing oracle 9i through Vb6.0
Hello Sir,
I am doing a project "visual-oracle". I have a problem in connecting the vb with oracle and accessing oracle through vb. In this project, we should able to create, delete, display and modify the table through vb (GUI)..
Please e-mail me the complete code for that.
A waiting eagerly to hear from you at the earliest.
Thanks in advance sir.
Best Regards,
Praveenraj.M
Accessing oracle 9i through Vb6.0
I am doing a project "visual-oracle". I have a problem in connecting the vb with oracle and accessing oracle through vb. In this project, we should able to create, delete, display and modify the table through vb (GUI)..Please help me to do this project..
ADODB
dfs* plz help for my Thesis Enrollment system I use ADODB but i dont understand how it work can any one plz help me My defence is on 3rd week of january hope any one can help me
vb6.0
How to Search in listviews
ADODB?
can you please tell me what SQL server are you using?what version?
--kiluah24--
Tool bar
i want you to send a coding how to use toolbar in vb 6.0
Crystal report
Please you to send me to connect crystal report and vb 6.0
Thank!
program code for connectivity of sql server to vb 6.0 with cryst
program code for connectivity of sql server to vb 6.0 with crystal report
make casio in vb 6.0
Please send a coding to make the casio to me
Thank!
in vb6.0 how to add guid to
in vb6.0 how to add guid to msacces plz hepl me
connectivity in asp.net with oracle sql server database
sir,
please guide me to connect oralcle database with asp.net by datagrid/pretty datagrid.
Thank you
Crystal Reports grrrr!!!
Hi everybody!!
I need to generate crystal reports without linking to database. I mean printing report values programitically. Pls help me out of this.
i nid tutorial in vb6 & msSQL 2005... help...
pls help me how to connect vb6 in msSQL 2005... and the control in listview.. tnx.... u can email me or contact me in ym... hir is my ym whiteboyzph.... tnx...
how to cennect vb6 to msSQL 2005?
can anyone help me? how can i connect vb6 to msSQL 2005? email me pls or add me in YM whiteboyzph is my ym.... tnx.....
Need a ADODB tutorial!!!!!!!!!!!!!!!!
sir, i have a project now...my project is to create database of a school management system...i want to connect VB interface with Microsoft Access database using ADODB and i dont know how to do it...can u help me sir? sir, i relly need your help for me to graduate this semester...
connect first create
connect
first create database
name your database firstMDB
then name your table myTable
then create fields, Name_ko,Last_ko
after you create database you can start coding in VB
create a connection on a module
Public connectFirstMDB As ADODB.Connection
Function load_data()
Set connectFirstMDB = New Connection
connectFirstMDB.Open "PROVIDER=MSDataShape;Data PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:\foldercode\firstMDB.mdb"
End Function
then on a form
declare
Public withevents rs_connect as ADODB.Recordset
Public Sub Form_Load()
on error goto err123 'in case an error occured
call load_data
set rs_connect = new recordset
rs_connect.Open "SELECT Name_ko,Last_ko from myTable",connectFirstMDB,adOpenStatic, adLockOptimistic
set datagrid1.datasource = rs_connect
exit sub
err123:
msgbox err.description
end sub
note: if your database contains nothing then error will occure telling "DATA ACCESS ERROR". just put at least 1 record.
i also have assignment
i also have assignment regarding withDBMS & data base approachs & file processing approaches. I search in th net but i found nonsense things... eerr wanna help me out here?
me too! i dunno iether
me too! i dunno iether
i can
give me your email i will give you example using adodb
vb6 Database Connection Method Step by step
Thnx for helping
for adodb example i need
hi, This is vijay.
I want to adodb examples. Pls send to my Email. ThankU
what your problem. i dont
what your problem. i dont care
i can giv u some code for
i can giv u some code for your project, ym me at coderz_its@yahoo.com
how to make a save button
how to make a save button that will display a msgbox when the field are incomplete...plz tnx....need dz today.. txtbck asap..^^
database
sir, i have a project now...my project is to create database of a student information system...i want to use a list view and i dont know how to use it...can u help me sir? sir, i relly need your help for me to graduate this year...
Master detail
Hi... Could You please send me sample of master-detail (form-grid) program, which is explain how to handle the edited grid (detail) rows before commit on delete/save. Thank You.
DHTML Application in VB6.0
Can anyone tell me how do I connect Access database using DHTML Application in VB6.0? I realy need this information for my new project.
Please help me out......
what database you want to
what database you want to use? or you can import reference ADODB to your project.
Accessing Database
In accessing database, what happens if you open an existing file in output mode?
True or false: your form must contain a different data control for every table in the database.
database
hi sir,
i want to create a database file but the problem is i dont know how to begin....can you help me..?can you give me a step by step tutorial sir?
tnx
cesar
pls tell error reports.
pls tell error reports.
I need a code for search inside a database from VB
I built an application to access an access database in VB6 using data object, I need to create a search code in order to fasten finding a value in a name column of this database
SAD
HI SIR, how can i connects or links the sql database through visual basic 6.0 and how can i sort the names of the person that are listed in my record... tnxx
OpenOffice Database
I want to create a database using OpenOffice database with ADO. It is possible? I've already configure using ADO component but the problem is "invalid format" something like that.
ADODB Connection to Open office database
hi I have read your question regarding Connection string to open office database
I am also in search of help for this problem but could not resolve my problem
have you got any idea
please let me know
thanks & regards
Sharad ( India - Mumbai )
about open office dtbs prob 'invalid format'
You better use microsoft access 2003, that would solved the problems XD
visual basic 6 with database(record,save,delet) process
i want to create a database software with vb6.i need to help that how can i link MS Excel datasheet with my database.
doubts in vb
hi sir.
this is shravan kumar. some doubts are listed below
1. how can add records in the vb6 using access database
Read the ADO tutorial above.
Read the ADO tutorial above.
Client server
How to access database in server using vb6?
how to access database in server from within my vb6 project
i have created a windows application which is currently using my local access database. I have uploaded the access database to a server. I would like to know how the connection is done to be able to access the data in the database..
thanks
adfadfa
adfadfa
Tables Relationships
i need help, when i want to works with more than one table that have relationships between them. how i can use vb6 to work with those tables and update them simultaneously..
alqamera, I'm not sure what
alqamera, I'm not sure what you are asking? The normal way I would do this is make the changes to one table and then the other one with the relationship. You have to do this in the right order otherwise you will get an error. Also you should check out the Stored Procedures tutorial listed above as this will show you how to do this within the database. Hope that answers your question.
VB 6 & Access
I would like to ask how to use MS Access data files in VB 6. I will be happy if you can give a tutorial on this. Thanks
VV
Post new comment