How to connect ComboBox to database in Visual Basic

Sdílet
Vložit
  • čas přidán 3. 08. 2013
  • #PinoyCZcams
    #vb6
    #PinoyProgrammer
    #VisualBasic
    Learn how to connect ComboBox to MS Access database.

Komentáře • 64

  • @12_parthgarware50
    @12_parthgarware50 Před 4 lety

    Nice vedio

  • @mirzanazeerbaig8798
    @mirzanazeerbaig8798 Před 4 lety

    brother your language I did not understand but the way you explained is very nice and easy to understand .

  • @12_parthgarware50
    @12_parthgarware50 Před 4 lety

    Nice teaching

  • @arg-sabtv22vid74
    @arg-sabtv22vid74 Před 3 lety

    this is good talaga ang daling ma-intindihat bawal line ng codes kung para saan at paano.. di dapat puro copy paste lang need din natin intinhihin yung codes

    • @JasonAsuncion
      @JasonAsuncion  Před 2 lety

      salamat po!

    • @arg-sabtv22vid74
      @arg-sabtv22vid74 Před 2 lety

      @@JasonAsuncion sir jason pansin ko lang po, bakit wala na pong latest uploaded ng vb6.0 tutorial. is it phaseout na po ba ang application na ito. kasi mostly lahat ng tutorials at mga codes ling is pawang 12 years ago na alng last update.
      as of this time I graduated as information technology wayback 2012 and then I am trying to remember lang or refresh those learnings na na obtained ko noon. and then maynaibabalik naman ding ala-ala ng kahapon.

  • @omrajeshkbangalore2092

    Thank you very much Sir....i was in desperate need and i got it from your Vid......
    Thank you very much sir again

  • @MrChum
    @MrChum Před 9 lety

    thank you jason sa tutorial mo
    atleast i know na pano mg gamit neto :D
    ilang tutorials ako nag search puro advanced naman
    you deserve my subscription
    matatapos ko na rin yung final project ko sa dbms.

    • @JasonAsuncion
      @JasonAsuncion  Před 9 lety

      Mr.Chum maraming salamat po. ginawa ko po talaga yun mga video tutorial na ito for beginner at gustong matuto

  • @lumbanglorena
    @lumbanglorena Před 10 lety

    thanks po sa info...learned a lot..,God Blesss!!!!!

  • @12_parthgarware50
    @12_parthgarware50 Před 4 lety

    Thank u...error solved

  • @tuyz6309
    @tuyz6309 Před 9 lety

    MAs natututo pa ko d2 kesa sa School :D
    hehe

  • @mikenmyke1230
    @mikenmyke1230 Před 11 lety

    nice sir:)salamat

  • @IamRenzx
    @IamRenzx Před 10 lety

    sana ikaw na lg teacher ko :(

  • @AndreaLynneAdriano2301

    Thank you. this helped a lot

    • @JasonAsuncion
      @JasonAsuncion  Před 9 lety

      Andrea Lynne Adriano You are very much welcome po :)

  • @MrSilbang
    @MrSilbang Před 10 lety +1

    master! Salamat hehe

    • @JasonAsuncion
      @JasonAsuncion  Před 9 lety

      Sil Christian Salazar maraming salamat din po

  • @jcsebastian6510
    @jcsebastian6510 Před 7 lety

    salamat :)

  • @MarcAndrew11
    @MarcAndrew11 Před 11 lety

    NIce tutorial sir. e yung sa registration po na may combobox panu mu po sya macoconnect sa database pagkatapos mu mag sign-up o mag register ?

  • @samsonteclezion1684
    @samsonteclezion1684 Před 8 lety

    its good but better change language

  • @ronelcarloenoc6531
    @ronelcarloenoc6531 Před 10 lety

    bakit po may error sakin? pag nagdedebug po ako, pag natapat ko po sa cn, nakalagay po cn=empty, lagi pong ganyan? help naman po

  • @norsheful
    @norsheful Před 7 lety

    kuya yan combobox na ginawa mong halimbawa diba hindi ka naglagay ng ado?., pwede rin palang sa code nalang ilagay?.,

  • @ryanahyong7842
    @ryanahyong7842 Před 9 lety

    Sir pwede po bang gumawa po kayo ng tutorial na login form na may combo box katulad po nung login form sa ginamit nyo na system salamat po

  • @claudineboholano5465
    @claudineboholano5465 Před 8 lety

    Pano po kung multiple name ang ilagay? yung eto na variable ang ginamean ko po.
    "rs!nme?"
    pwede po ba ito? rs!LastName FirstName ?

  • @elmerperalta9067
    @elmerperalta9067 Před 10 lety

    Sir maraming salamat po,,ask lang po sana ako ng help,,,ano po ba ang code pra hindi mag save incase may rong duplicate ang data sa dbase like pangalan ng tao,,,,thanks po

  • @norsheful
    @norsheful Před 7 lety

    kuya, pwede po ba ako magtanong about how to print image in data report po?.

  • @jasonrose5583
    @jasonrose5583 Před 8 lety

    Good day sir Jason 😁 ask ko lang po kung possible po ba na ma-call ang makakahiwalay na database sa iisang ComboBox? Thank you in advance sir :)

  • @RushVin102
    @RushVin102 Před 11 lety

    Sir ask lang po kung papano yung source code kapag gusto mong kopyahin yung items ng listbox sa form1 papunta sa listbox ng form2, by means of vb6, possible po ba un?

  • @162001
    @162001 Před 11 lety

    question Sir, how do I go about populating text boxes in VB6? more like in the purpose of searching a record, I would like to have a function where i can browse records from a form. thank you.

  • @154nc
    @154nc Před 11 lety

    paano po ba e add yung laman ng database sa textbox:
    for example: i have an database ms access and im currently creating a inventory system, i want to populate all the data added in my database to my textbox espicifically.
    Like: PRODUCT NAME: I HAVE 4 entries in my database and i want to dispaly it all in my textbox.
    IN DATABSE:
    MILO
    COFFEE
    MILK
    SUGAR
    IN FORM(VB6):
    eto ang ma edisplay nya:
    textbox=MILO, COFFEE, MILK, SUGAR
    THANKS PO.

  • @jackysam-donoorinoco5585

    sir pano po yung program na magsave ng image sa vb 6 to database ? sana maipost niyo tutorial thank you po

  • @hengthyra3227
    @hengthyra3227 Před 9 lety

    thank you for video but if i want select value as id. how do i do?

  • @skynetcyberdyne7179
    @skynetcyberdyne7179 Před 7 lety

    good evening
    How to read in vb6 the bluetooth SSID in a textbox?

  • @michaeltan9028
    @michaeltan9028 Před 8 lety

    sir panu po pag specific data lang ang ilalagay nio?for example mga doctors lng gusto mo palabasin sa combobox, kaso may iba't ibang designation tulad ng Admin, Nurse etc?

    • @michaeltan9028
      @michaeltan9028 Před 8 lety

      +Michael Tan ganito po codes ko
      Set dr = New ADODB.Recordset
      dr.Open "Select * from UserAccount where Designation='" & "Doctor" & "'", con, 3, 3
      Do Until dr.EOF
      cboDOC.AddItem dr!LastName + "," + dr!FirstName
      dr.MoveNext
      Loop
      Set dr = Nothing
      nagkakaproblema sya kasi dumodoble ung lumalabas sa combobox

  • @davidhouser9280
    @davidhouser9280 Před 3 lety

    How to add multiple adoc files to a pulldown list in vb6?

  • @rewardlabel
    @rewardlabel Před rokem

    Brother, how to show 2 coloumn populate data

  • @aubreyjoyrosales3025
    @aubreyjoyrosales3025 Před 10 lety

    ano po ung ksunod nung 'rs.open "select*from doctor", cn, ?, ?,'

    • @JasonAsuncion
      @JasonAsuncion  Před 9 lety

      Aubrey Joy Rosales eto po ibig sabihin nun 3,3
      adLockPessimistic Pessimistic locking, record by record -- the provider does what is necessary to ensure successful editing of the records, usually by locking records at the data source immediately upon editing.
      adLockOptimistic Optimistic locking, record by record -- the provider uses optimistic locking, locking records only when you call the Update method

  • @olrakpogi2338
    @olrakpogi2338 Před 5 lety

    Sir bakit walanf lumalabas na open kapag nag tatype ako ng rs.

  • @benedictcoles484
    @benedictcoles484 Před 10 lety

    SIR MALIGAYANG ARAW PO SA IYO,
    MAYRON PO BANG DATE PICKER SA VB6.0?

  • @chengchung9547
    @chengchung9547 Před 9 lety

    what if sir may duplicate na data sa db? pag view nun sa combo dupli din .. panu nyo sir ihahandle un? or i fifilter?

    • @JasonAsuncion
      @JasonAsuncion  Před 9 lety

      Cheng Chung try nyo po panoorin itong video ko na ito about data filtering czcams.com/video/C7xAl51iJ9U/video.html

  • @ramanjeetkaur8763
    @ramanjeetkaur8763 Před 4 lety

    Sir it's showing error. What is cn,3,3 for?

  • @marvinnabus5439
    @marvinnabus5439 Před 9 lety

    sir.. ok lng ba khit gmitin ko ung MS Access 2k13

    • @JasonAsuncion
      @JasonAsuncion  Před 9 lety

      Marvin Nabus opo,wala naman po ako nakikitang problema dun

  • @ikegaamil453
    @ikegaamil453 Před 11 lety

    Sir, ano ibig sabihin sa 3,3 ?

  • @lorenzoruuu_sja
    @lorenzoruuu_sja Před 8 lety

    Kuya, Pano po kapag kuwanyari eh ComboBox po nilagyan ko ng Male at Female, pano ko po ito icoconnect sa access? Mag a-aadd po ako ng Student Information ang gusto po ng guro namin eh may combobox.

    • @JasonAsuncion
      @JasonAsuncion  Před 8 lety

      +Luke Ruga parang eto na yata yun sagot sa tanong mo. medyo malabo kasi tanong mo eh, gusto mo ba masave un i-type mo sa combobox papuntang database?

    • @lorenzoruuu_sja
      @lorenzoruuu_sja Před 8 lety

      Ganito po kasi dun sa combobox, ilalagay po namin Male at Female, tapos kapag mag aadd po kami ng Student Info gamit ang vb6 hindi ko po alam yung codings o gagawin sa ComboBox para magconnect sa access parang sa textbox

    • @JasonAsuncion
      @JasonAsuncion  Před 8 lety

      +Luke Ruga simple save command lang yun para masave un laman na pinili sa combobox

  • @gindama3447
    @gindama3447 Před 10 lety

    sir repost ko lng yung tanung sa inyo ... anu poh yung mean nun.
    "select * from doctor",? , 3, 3"
    yung (cn) poh anu poh yun??

    • @gindama3447
      @gindama3447 Před 10 lety

      uu

    • @Seklnf
      @Seklnf Před 9 lety

      Gin Dama
      ano po ung 3,3?

    • @JasonAsuncion
      @JasonAsuncion  Před 9 lety

      tingin ko kailangan nyo pa panuorin yun iba ko pa mga video par amas maintindihan nyo, kasi naipaliwangan ko na yan. Kung kokopyahin nyo lang yun code, hindi nyo ta;laga mapapagana kaya mas ok maintindihan nyo

    • @JasonAsuncion
      @JasonAsuncion  Před 9 lety +1

      eto po ibig sabihin nun 3,3
      adLockPessimistic Pessimistic locking, record by record -- the provider does what is necessary to ensure successful editing of the records, usually by locking records at the data source immediately upon editing.
      adLockOptimistic Optimistic locking, record by record -- the provider uses optimistic locking, locking records only when you call the Update method.

    • @gindama3447
      @gindama3447 Před 9 lety

      sir need po namin ng speaker sa seminar :) from sta.cecilia college reps po sir asap :)

  • @jasoncarillo5153
    @jasoncarillo5153 Před 5 lety

    sir how to add two dates ??

  • @user-oh7qv4lk1n
    @user-oh7qv4lk1n Před 4 lety

    arguments are of the wrong type, are out of acceptable range, lr are in conflict with one another

  • @lumbanglorena
    @lumbanglorena Před 10 lety

    ask po ako ng help kung pano mgcode sa vb 6 tungkol sa library managemnet system para sa pgborrow at pg retrieve ng books..
    lumbanglorena@yahoo.com..Thank you very much!