Saturday, February 7, 2009

Sample program using ADODC WITH DATABASE.

This VB6.0 program allows user to add, edit, delete, search by option and display record using ADODC RECORD and ADODC CONNECTION. Microsoft Access for the DATABASE of this Program.

















You can download my example below.


Download File

77 comments:

  1. aNg HiraP paG biggineR qa p Lng!!! :(( aT d mxyDo naG prO2gram keA keLngang PumaXa!! :((

    ReplyDelete
    Replies
    1. sobrang herap tlga ng vB 6.0 through database...

      Delete
    2. hindi kaya bobo k lang :) pizz dude

      Delete
    3. kaya namn, natry ko adodb a vb.net 2k10 sa system ok naman,. ewan ko kung anu pagkakaiba nun sa adodc connection

      Delete
    4. I know the feeling bro >.<

      Delete
  2. dapat mag post kau ng mga vb na connection thru mysql or mssql pra nmn mpagaralan din noh,,,

    ReplyDelete
  3. is it free error?

    ReplyDelete
  4. That program i uploaded is very simple program.. you need to study more

    ReplyDelete
    Replies
    1. pwede ba sample lib system mr paler

      Delete
  5. yan try nyo VB sa html pwede rin pala...

    huhuh

    watch nyo ung simpleng ginawa ko...
    sa email ko naka connect...

    www.vajohn.50megs.com

    tnx...

    i reli love VB tlga kaso 6.0v ang medyo alam ko konti...hehehehe^^

    ReplyDelete
  6. Replies
    1. help us with our library system program naman po using vb 6.0.. ano po bang number mo? add me nalang sa fb risam_ksb13@yahoo.com po thanks ill wait for your response

      Delete
  7. Ei..bakit hindi mabuksan ang ms access..may password...pwede ko po bang maaccess ung database nito???

    ReplyDelete
  8. elow po sir john.. pano ko po change un path .. kc di mhanap ung distination nung database na dbStudent.mdb.. ang ginawa ko ginaya ko na lng ung path D:\JPLR\VB6.0\Lecture\vbADODC\vbStudent.mdb... it works :).. pero like ko sana malaman kung pano ung change ung path.. xenxa na sir.. newbie pa me sa VB..hehe,tnx sir

    ReplyDelete
  9. The database is not protected of any password or security.. you can acces the database immediately.

    ReplyDelete
    Replies
    1. tama!!! kaso pede din po yan lagyan ng password di ba po?

      Delete
  10. I want you to open the program and goto form1 i want you to right click 'ADODC1' and click properties and click 'Build'..
    And browse the database dbStudent inside vbADODC Folder... And try to click Test Connection..

    ReplyDelete
  11. pwede ba magbuild ng connection gamit ang ado data control na hindi sa properties ginagawa,gusto ko kc sana ung sa code..na try ko magbuild gamit ung adoDB lang,,gus2 ko adoDC (ado Data Control)..Help me Guyz!

    ReplyDelete
    Replies
    1. pede un nagawa q na.. bigyan kita instruction qng panu.. kaso may lagay lang haha

      Delete
  12. pahingi naman ng sample program ng add, edit,delete,save sa vb 6 using adodc and ms sql 2005,,,please!! ^_^

    ReplyDelete
    Replies
    1. grabe naman 2! lahat tinatanung mu na sa kanila. tutal nag ne-net ka naman bakit d mu itry sa google maghanap or sa youtube! dami mu makikita dun.

      Delete
  13. Hello sir, im a newbee in your site, also newbee din ako sa VB..., im having a problem lalo pa at im running out of time na, kc i need it on wednesday this month..., im making a program of Add, Edit and Delete in VB6 using sql..., the very first problem is i dont know where to start...., actualy i do have an idea already to make the VB code, pero ung pag create ng connection to database di ko alam..., please reply immediate sir..., i'll wait for it.. thanks..., i'll appreciate your help a lot sir...;j

    ReplyDelete
  14. Hello, will you help us to our project?..it's about file management/database...tnx

    ReplyDelete
  15. hello sir.. pano po gamitin ung crystal report sa vb6?.kaso nga sir eh. hindi ako mdyo marunong sa crstal. pwede ho bang sample? gusto ko po kcng gumawa nang referral letter nang madalian.. ung addressee at chaka name nalang ang ma palitan.. to minimize paper works redundancy. please

    ReplyDelete
  16. good day po sa lahat, beginner po ako, gusto ko lang po itanong kung meron kayong idea kung paano i connect ang vb6 sa mysql via network... sana po matulungan niyo ako. thank you...
    Henry of Pampanga
    apalit2k@yahoo.com

    ReplyDelete
  17. BOss ask ko lng about dun sa bug ng adodc...

    minsan kpg more than 1 ung adodc ko sa form ayaw na mgconnect ng iba... my error po cya..
    e2 po ung nlabas..


    "Run-time error '91':Object variable or with block variable not set"



    Panu po b un?
    Advance thnks po!

    ReplyDelete
  18. hi,dis khaty..phingi nmn sample codes like import data from SQL to excel file using VB6.0...pls??tnx po..hope u can help me,sir???

    ReplyDelete
  19. @khaty: Ok kathy i'll send you a copy of program like you requested now just send put your email address.

    @David: Just right click the adodc1 object and press properties, browse you dabatase in order you will get the address of your database (msaccess) then the program will know the address of the database.

    @Henry of Pampanga: Henry to connect the program via network its very simple you just need to get the path of your database, because if the program will know the path of the database then it will automatically connect via network.


    If you comment and question just ask me in this email johnemisylpaler@yahoo.com.ph or you can contact me in this blog site. thanxxxx

    ReplyDelete
  20. hi sir...pde po bang mkahingi ng copy ng sample for applicants record system...vb6.0 poh gamit nmen ska ms access poh ung database namen...hope ma2lungan nyo poh kami...tnx poh...

    ReplyDelete
  21. Anonymous@ May i have you email so that i can send you the sample program. tnx

    ReplyDelete
  22. ,.,pano ba mag.gawa ng sarili mong pattern sa program moh,,.kagaya nang thesis,,.,.na magkatugma din sa documentation ng thesis moh,.,.,

    ReplyDelete
  23. sir, ano po b ang codes pra pag inenter ko ang password ng admin m mbu2ksan nya lhat pro kpg staff nman po limited lng ung mggwa nya s form..tnks

    ReplyDelete
  24. mga ulol kau ang bobo nyoh naman tang ina nyoh pah


    ang hirap mag program pag nami2ntal block pah tang ina nyoh kc ulol pah kau

    ReplyDelete
    Replies
    1. bait mu dong...
      TALINO Mo. Hiyang hiya naman kami sayo. hahaha

      ,,|,,

      Delete
  25. sir panu po ba ung codes para makagawa ng LAN or INTRANET CONNECTION? VB 6.0 po gamit ko tapos MS ACCESS ung datbase ko then ADODC ung connection na gamit ko., hope for your response sir., thank you!

    ReplyDelete
  26. sir panu po ba ung codes para makagawa ng LAN or INTRANET CONNECTION? VB 6.0 po gamit ko tapos MS ACCESS ung datbase ko then ADODC ung connection na gamit ko., hope for your response sir., thank you!

    ReplyDelete
  27. @jessi: you just need to specify your path if where is the Datbase program located in you disk. send me you program I'll set it for you.

    ReplyDelete
  28. can you give a code to display the exact data or example when i input "P" only data that starts with letter "P" will display... i appreciate if you can give me that code tnx

    ReplyDelete
  29. Salamat sa VB Program,this will help me much...thanks...and God Bless

    ReplyDelete
  30. wow it's really nice trick..
    help me to finish my job..
    thx.

    ReplyDelete
  31. sir pde ba mkuha num mo?? pkisend n lang sa email ko e2 o darkz_15@y.c
    pahelp lang sa thesis my itatanung lang ako ty

    ReplyDelete
  32. Sir heLp me naman. can i ask for a code for search button using adodc..tnx poh :]

    ReplyDelete
  33. what we need to study if there so hard to understand very well hay john can i need your help...

    ReplyDelete
  34. hindi ko poh maintindihan mbuti ehh my program s about library setting..ayaw n nyang gumana pag dating sa pag boborrow ng book!!yaw nya mag connect!!hepl nyo nman ako nid ko n yun at aug.7,2010 tnx poh sa mkakatulong

    ReplyDelete
  35. Send me the file i'll check your code for you.
    johnemisylpaler@yahoo.com.ph

    don't forget to check you database connection maybe u have the problem there.

    ReplyDelete
  36. pohta ang hirap ng programming

    ReplyDelete
  37. Hello Good Morning. Sir pwede po ba makahingi ng sample program para sa record system ng employee. Access po gagamitin. pwede po sir pakisend na lang sa email ko. aureliochester@yahoo.com. Thanks sir...

    ReplyDelete
  38. hi po im aiz... sir help me naman po sa gnagawa ko ng program..baguhan palang po ako..pd po ba sample program ng hotel booking system..access po gagamitin..thanks..send nalang po sa email ko..aiza0417@yahoo.com.ph

    ReplyDelete
  39. sir hinge din po ako code panu e connect ung database ms access sa vb 6.0..ung hotel booking po...again im aiz..pls sie help me.

    ReplyDelete
  40. anu pala ang code ng program na yan??tnx!!

    ReplyDelete
  41. pre sure ka ba gumagana 2? di kc gumagana sakin e

    ReplyDelete
  42. sir, jhay poh ito, pde po pasend ng sample program where i can save and retrieve picture in adodc,.. like personal profile xecretly24_05@yahoo.com,...

    ReplyDelete
  43. sir, pasend nman ako ng working, ayaw po kasi.
    ceril_07@yahoo.com mail ko. thanks

    ReplyDelete
  44. dq mdownload ung files mo kuya :(

    ReplyDelete
  45. Can ADODC be a client server?

    ReplyDelete
  46. thanks for this kind of examples it helps us a lot, Merry Christmas,

    ReplyDelete
  47. Anonymous said...

    Can i ask for a sample grading system for school..it make it harder kasi eh...
    ..vb ang gagamitin

    ReplyDelete
  48. I am trying to specify the connection string in code and have used the code below that I found in the earlier threads.

    Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=C:db1.mdb"
    Adodc1.CommandType = adCmdText
    Adodc1.RecordSource = "Select Field1 from Table1"
    Adodc1.Refresh

    This seems to work but the connectionstring line gives the following error:
    [microsoft][ ODBC Driver Manager]Data Source name not found and no default driver specified.

    I would appreciate any help I can get in this matter.
    thanks in advance

    ReplyDelete
  49. hello. pede po bang maopen ung sample program n yan using vb 2010? o kaya pde po bng magrequest ng sample program with database na gamit ang visual studio 2010? tnx po.

    ReplyDelete
  50. ibankarlo@yahoo.com po email ko,

    ReplyDelete
  51. ..hello poh anu poh bah source code nang edit sa adodc po.?

    ReplyDelete
  52. hello guyz
    i need a library system with database can you show me sample
    thnx ^_^

    ReplyDelete
  53. ..aw? anu ba tong prog na to??? ang WEAK2x nman..kulang3x pa

    ReplyDelete
  54. ..Library system? ok post mo ung account mo. para ma send ko ung prog.. pag aralan mo nlang :)

    ReplyDelete
    Replies
    1. sir pasa mo din naman skin ung program ng library system,.,.kelangan q lang po,,i2 po ung email add.,.,.,buglaw_17@yahoo.com

      Delete
  55. I need a lbrary system too using adodc

    ReplyDelete
  56. i need a program that can add adit save update and search using adodb and ms access. . . pwede po makahingi ng code beginner pa lang po kc ko pls! pls! send the code sa email ko kylezeroine@yahoo.com Thanks much!!

    ReplyDelete
  57. love you it nice you solve my problem with i was facing from since last mouth

    ReplyDelete
  58. Sir..
    meron po ba kayong program using adodb..
    with shockwave flash player sa intro..
    may add edit delete search..
    ksi po ung ibang adodb nid ng data pra mag run..
    nid ko po ung hnd na kailangan ng data pra mag run..
    ako nlng mag aadd mismo..

    asap po sir..

    send nyu d2...

    jonnardliam@yahoo.com

    big thanks...!!

    ReplyDelete
  59. Sir, meron kayong sample program for library management system using vb6? Pag-aaralan pa kasi namin yan.. Please send me a copy
    bluskies18@yahoo.com

    thank you

    ReplyDelete
  60. tutorial po pra sa pag search ng database sa vb6.0 using adodc.. or sample program.. kelangan ko po kasi... tnx

    rakiztah26@yahoo.com

    ReplyDelete
  61. panu b gmitin ung adodc taz ang connection string eh my "APP home.db" xa dulo

    ReplyDelete
  62. hehe sarap tlaga ang feeling pag tapos kna sa system mo noh.....
    I'm done LIBRARY SYSTEM......

    ReplyDelete
  63. mga gago. easy lang kaya mag connect..... baka NURSING ANG MGA COURSE NYU....

    ReplyDelete
  64. hello sir, im newbee in your site...and also newbie in adodc, ask ko lang po kung panu mag connect in database to textbox ? tnx po ng marmi sa help :)

    ReplyDelete
  65. gud pm po sir. pwede po ba akong magpatulong sa vb6.0 employee record management system, ang deadline po ng pasahan sa friday. please po sir wala pa po aqng nasisimulan

    ReplyDelete

 

blogger templates | Make Money Online