Search
ADO
Submitted by cedrick blas on Wed, 02/10/2010 - 15:08
Level: Beginner
Language: Visual Basic
819 reads
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Language: Visual Basic
819 reads
i just wrote this code for the beginners cause i found out that some users need an introduction to ADO and how to connect vb to access.. features (ADD, UPDATE, DELETE, SEARCH) para sa mga kapwa source at beginners :) sana makatolong mamats!
Download Code
Your Vote!
Note
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note:All files are scanned once-a-day by SourceCodester.com for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
- 819 reads
Relevant Content
- Progress bar
- User Authentication Program
- Billing System
- VB 6 and MySQL Database Operations - RE-UPLOADED
- A Simple Add, Edit, Delete, and Search using VB and MSAccess
- Client-Server App with Flash and PDF Reporting
- Transmittal Record System
- Simple Database Manipulation in c# using ADO.NET
- Information System
- Point of Sales with Access Back-end
hi
just wanna ask..
i create a program that add, save, and delete data. i used visual basic 2008 express. first, is there have any difference between visual studio 2008?
second as i click the save button. the data that i input to my textbox is automatically save in my database. i use access as my database. but after i closed the program all the data that i save is already gone. here is the code that i used.
me.validata
me.student_infobindingsource.endedit
me.tableadapter(me.sampledataset)
can you help to find what wrong why all the data is automatically deleted as i closed my program.
and can you give me some code for verifying whether the data already exist like the userID.
here my my email. aslan072000@yc
thanks.
i look forward for the response.
^_^
aslan07
download this:
http://www.sourcecodester.com/sites/default/files/download/cedrick_blas/...
ahmp i never tried creating program using vb 8.0 my latest software is vb 6.0 and visual studio 2008 prof ed.
i thing the only difference bet. the two is that in manipulating database
in vb 6.0 com object is very powerful tool cause of its ADO library while in .net u dont need to add more referene cause ADO bcme ADO.net
u use a tableadapter and thats not good for me..
in vb 6.0/8.0 u can use ado in manipulating data
so two ways of coding yan either ull use Recordset or Connection in inserting data such as (compile nalag ako dito huh hehehe)
Dim rs as new adodb.recordset
Dim cn as new adodb.connection
Set rs = new Adodb.Recordset
rs.addnew
rs!fieldnameofdatatbase1 = text1.text
rs!fieldnameofdatabase2 = text2.text
rs.update
or the use of connetion
cn.execute "Insert Into table1(username,password) Values('" & text1.text & "', '"& text2.text& "') "
sana makatolong refer to my code and other odes hir..salamat poh sa inu :)
Cedrick Blas
www.nwuicons.ning.com
www.greenhurtz.multiply.com
undying_emolove@yahoo.com (FB,FS,YM)
Good Luck Guys!
<<
hello
ahm sa visual basic 6, medyo nalito ako kong panu e empliment eh, ahh same way of coding lang pala
hello
yap same way of coding hehhe actually nag start din ako sa vb 6 sa advanced lesson ko peu vb.net tinutoro samin so 2 background ko hehehe
yap same way of coding lang kaso mas matiik .net hehehe peu kung com object pag uusapan sa vb6 :) parang pag switch lang ng ADO to ADO.net
re
di kopa na try mag use ng oracle eh kasi wala me oracle.. peu ano ba yan? sa vb 6 bayan? .net?
hello
marunong ka gumawa ng log in/ log out, na oracle 10g yung database??
hellow
never ko pa kasi na try mag program gamit oracle eh hehe
senxa na peu same ways of coding lang sila.. VB 6 ba? o .net? to oracle?
Post new comment