RSS: Site FeedDatabase 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 backends. 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 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
- Printer Friendly
- 137952 reads
Comments
heeloo..
can you me help 'bout menu editor code? please.......
ppl help me out
ppl help me out plzzzzz.....
i need vb 6.0 software fr ma prjct...
i have it.whr r u?
i have it.whr r u?
VB 6.0 s/w domnload???
Can anyone suggest the site to download VB s/w
ENGLISH! Y'speak it?!?
ENGLISH! Y'speak it?!?
ADO and Winsock
Hi to all,
can you help me to create a program which is using an ADO Database via winsock?
thanks
sql statement problems
using sql statements, i can access my database, but there some problems i dont really know what to do..
help me please with these...
i tried to execute the following.
update table_name
set field_name = txt_field.text
where field_name = txt_field.text
the error was: data type mismatch.
the thing is i know what the error means, but it was nonsense, cause im sure im right about my data types
and when i try to cut condition in my sql statement, it successfully run....
then....
delete from table_name where field_name = txt_field.text
the thing is that it successfully run but npthing happen, no errors.
please help me with these.
im a student, and trying study well, please help me with these..
thanks..
Using Access Database Having Password
hi,
i can use access database without password from vb 6.0 but i can't use access database having password, and it shows error. so if any can solve this problem please reply me.
Help me for my project
i need source code in VB for the meter polling procedure for the outage restoration in electrical distribution system...am not getting properly..it need urgently
hello
pls help me for making project(collage management) by taking backend and frontend in visual basic
addnew comment(dao) in vb6 using coding
i Want to add new records in access database using coding in vb6
excellent set of steps... is
excellent set of steps... is a very impressive and useful resource
how to show the database of
how to show the database of mysql in vb6 ................. how to query ??? i need its coding can u plz help me out with it
Inquiry
Hello there!
May ask how to make database using MySQL as a backend and Visual Basic 6.0 as frontend?
Need help on this.
Thanks.
Kind regards,
Rey
airline reservation system project code
SIR..I AM A STUDENT IN 12TH. I WANT TO DO A PROJECT ON AIRLINE RESERVATION SYSTEM.PLEASE HELP ME WITH THE CODE AND FORM DESIGN,USING VB AS FRONT END AND ORACLE AS BACK END. IT IS TO BE DONE WITH ADODC CONNECTIVITY,,,SIR PLEASE DO HELP ME....PLEASE...
DO SENT IT TO ME IN rinieliza_1392@yahoo.co.in
Use of Data Grid as Input for an Invoicing System
Dear Sir,
I am a new member of the site of VB6. It is a very usefull site. I have learnt a lot from this site. As concerned to my problem, it is that i want to use Data Grid for capturing a Sales Invoice Entries. How do i can use Data Grid as for Data input and also tell how can I validate the fields of Data Grid, while using it as Data Entry tool.
If it is not possible to use Data Grid as data entry tool , please guide me to some other way to capture a Sales Invoice entries.
Thanking You
Regards
6Nazakat
how can i make a data base w/ log in function ??
how can i make a data base w/ log in function ??
i want to pass this project into the accounting office of our school for additional grade ..
please help me about this matter ..
im a second year college student and 18 years of age ..
thanks a lot .. hoping to be guided ..
-- just asking ..
how to add data to access database using adodc
i have connected my adodc to my vb,but when i add a new record, it deletes the previews record.i need urgent help
what is your code?
post your code here so we may help you :)
code for edit in vb6 to be linked to MS Access
what is the EDIT code for vb 6 to be linked to MS Access? pls.. help.. tnx.. i just need the code for edit.. here's my code for add and delete:
Private Sub cmdAdd_Click()
Call Open_Conn
If cmdAdd.Value = True Then
cn.Execute "Insert into table1 values(' " & Trim(Text1.Text) + " ',' " + Trim(Text2.Text) + " ')"
MsgBox "New Record Saved!", vbInformation, "Added"
Call Close_Conn
Else
MsgBox "No current record", vbInformation, "Error"
End If
Text1.Text = ""
Text2.Text = ""
End Sub
Private Sub cmdDel_Click()
Call Open_Conn
cn.Execute "Delete from Table1 where Name=(' " & Trim(Text1.Text) + " ')"
MsgBox "Record deleted!", vbInformation, "Info"
Call Close_Conn
Text1.Text = ""
Text2.Text = ""
End Sub
Database SQL Queary
I Create a Student database. Now i want to Search any fields and i want to use SQL Code. I use Access Database. How can make SQL Builder Form? Than How can Print my Form? Please send same Project and code. This Email: zubair_312@yahoo.com
Print code
I want to print code. Because i cannot print my form.
search engine
If Request.QueryString("search") <> "" Then
rowInfo.Text = ""
Dim search As String = Request.QueryString("search").Replace("'", "''")
Dim sqlstring As String = "select * from faq where question like '%" & search & "%' OR subjectHeader like '%" & search & "%' "
Dim search1 As Array = search.Split(" ")
If search1.Length > 1 Then
Dim i As Integer
For i = 0 To search1.Length - 1
sqlstring = sqlstring & "UNION SELECT * from FAQ Where question like '%" + search1(i).Replace("'", "''") + "%' or subjectHeader like '%" & search1(i).Replace("'", "''") & "%'"
Next
End If
i have a search engine but it can only search by 1 word when i type more than 1 word, there will be an error,why? i need to allow user to be able to type more than 1 word..how?
try and try untiL u find
try and try untiL u find it... like what i did... it works... =)
vb6
hi..we wanna know if vb6 is compatible with access 2003.
thanks!;'D
Yes
Yes
Convertion
Just create your access 2003 and when you are throw, go toopen, select the database and click the arrow beside open, then select open exclusive. then go Tolls>convert and convert your database to access 97 format
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
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...
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
Post new comment