Unique Adding of Records (vb6 demo)

[MrSexyback666]

2:25

[ZeroCool2211]

Dude you are a genius! thank you for this video, it helped me a lot

[stamboi08]

paano po pag galing sa list box ung ilalagay ko sa database how po un?

[ashdesignz2008]

@stamboi08 - mejo complex coding nyan, its more on array, i recommend reading on forums with other programmers such as programmers haven, di na kasi ako makagawa ng maraming tutorials eh.

[starcatcher164]

may ibang paraan po ba bukod sa paggamit ng ADODC para maconnect sa database?

[ashdesignz2008]

@starcatcher164 - DAO process, search mo sa google, how to connect database using DAO in visual basic 6

[t3nkyu]

@starcatcher164 meron pa gamit ka ng Data Environment

[yamim33]

@starcatcher164 .. sir panu po ba mag edit at magsearch ng data..???

[ashdesignz2008]

@yamim33 - nagbigay nako ng idea on how to construct adding records, nasa add records na ang pattern on how to edit and search, i can't create more tutorials on net cause i have job, and I'm focused more on PHP, try to research more, read forums on programmers haven

[joyberts]

alam mo ba kung paano magbato ng laman ng access sa label, bale yung laman ng field 1 mapupunta sa label 1 mga ganun. lam mo kung paano?

[ashdesignz2008]

@joyberts - gumamit ka ng recordset.!fieldname function, tapos set mo sa label o kaya textbox, example

label1.caption = adodc1.recordset.field!firstna­me

[severmind20]

Meron kapo bang sample naman for UPDATING DATA in Database??

[ashdesignz2008]

@severmind20 - pattern lang is "adodc . recordset . update" try to read more on other programmers forum such as programmers haven

[gutless31]

Amazing.. i will try this some time...

[meichum]

kuya online po ba kayo ngayon?

[apappipap]

salamat ng madami

[november212007]

hindi ba pede kung list box at label ang ipalit sa textbox?

[ashdesignz2008]

@november212007 - pwede po, depende na lang din yun sa paraan ng iyong pagpoprograma.

[november212007]

@ashdesignz2008 ou pede nagawa ko na konting edit lang dun sa command click saka hindi rin pala pedeng may space dun sa adodc1.recordset!username kahit may space sa database kelangan walang space.

[november212007]

ito ang matagal ko nang  hinahanap

[apappipap]

bossing paano pag multiple table ang gagamitin?

[ashdesignz2008]

@apappipap - magdagdag ka ng panibagong code, for example yung adodc1 is for table1, magdeclare ka din ng adodc2 for table na gsto mo ding gamitan ng fucntion.

[gabriel7840815]

sir gwa nman kaw ng login tapus pagkalogin lalabas ung gnwa sa microsoft access d ko kasi magwa..yung pdeng mdming pass at username ang pdeng mgmit pg nglogin..

thank you

[ashdesignz2008]

@gabriel7840815 - hindi na secured ang program na gagawin mo kung pwede gumamit ng madaming pass or username o ang ibig sabihin mo eh multiple usernames ang pwede magamit, tatanggalin mo lang ang conditional statement ng find at adodc1.recordster.eof to find something, add ka lang ng add, yun na yun

[trixz15]

kuya number lang po ung lumalabas eh.... ndi po ung username na nakalagay dun sa database... pag nasave na op ung name ndi na po ba un pede maedit? or para lang po mag appear dun sa textbox ung username na naiclick ko.... thanks po.....

[ashdesignz2008]

@trixz15 di ko nagets question mo, isa isa lang po, kung number ang lumalabas imbes na text, please follow the correct format of sql statements, kung character siya dapat may single quote sa magkabilang dulo, pag numberic naman dapat wala, logical error lang po ang problem sa coding nyo po. konting debug lang sa sql statement.

[trixz15]

pano pag gusto ko iedit ug username na na add ko na? ano code nin kuya??? thanks....

[ashdesignz2008]

update code.

adodc1.recordset.update

[afirahsrex15]

nice =D

[Mern04]

sir ash!!! ok na. nkuha q na ung pg nhighlight ung row xa lng mddelete. haha. salamat sir ash helpful vid mo. thankx po. :)

[Mern04]

sir ash pnu pg iddelete n ung nilagay mung record? anu code nya po? :(

[ashdesignz2008]

adodcname.recordset.delete

try to create muna ng adodc object then set mo yung table sa adodc na yun, then declare that code in a button with the sql search on an object like "Select data from tablename where blah blah blah = blah blah blah" basta it's up to your imaginations on how to program ^^,

[Mern04]

sir ash. kc po ung gingawa q prang ganyan pro hindi xa username password. prang fname lname ganon po, tnung q lng qng pnu pg mag ddelete k lng ng isang row sa grid ska mddelete n rin po xa sa database, prang pg n highlight ung row xa lng po mddelete, :( plss help po ung n lng problem q, pa help po sa codes.. :(

[YouGotZero]

sir ash pano pag d ko ggmtin ung adodc1.recordset pde q ba eh delare ng gan2 - dim rs as new adodb.recordset?

[ashdesignz2008]

eh di rs na mismo ang shortterm, kung tatawag ka ng field, eh gagamitin mo, rs.!fieldname

[YouGotZero]

ok!! sir , maraming salamat laking 2long nang video niu.. :))

[romayne15]

galing.. :D ACLC GUAD!

[paolocdn]

salamat sa post boss... ayos to....

pa request nmn.. panu gamitin ung "where" "insert into" saka ung ibang common sql commands... hehe..thx boss

[ashdesignz2008]

yung where nasa conditional statements na lang po yun, sa may adodc1.recordsource = "Select blah blah blah from blah blah blah where"

sabay dadagdagan mo ng adodc1.refresh tsaka set mo sa datagrid

[ashdesignz2008]

yung insert into, yan na po sa demo, add ang function nun, para sa where, gamitin mo sa pag set ng adodc1.recordsource = "Select * from tablename WHERE blah blah blah = blahblahbla"

[mulder195]

Ok...i am not good in english.....

I will try with that code....

Thx

[mulder195]

Does anyone knows how to find record ( data ) in database......i make'd a database but i dont know how to search one data.....if anybody knows please answer me on pn or in this comment !!!

Thank you anyway !!!

[ashdesignz2008]

adodc.recordset.find command, please explore more using the button

[kuyetwanted]

hi.. nice vid!

im actually a student and required to provide a system..

basically.. uhmm.. its more on database,

it so hapen that im on your page coz it provides me the answer im looking for.. *thank you ^^,*

one thing that bothers me a lot.. uhmm. how can i come up with DROPDOWN LIST where in all my inputted records is in there..

just sneakin in your time.. hope ur not busy.. hehe

ur response will be appreciated.. swear!.. ^_^

[ashdesignz2008]

hmm, try setting up the adodc recordset to the combo box by using the comboboxname.additem = adodc.recordset.fields(index)

[kuyetwanted]

thanks! ^_^

[microsohk]

Thanks Again John.. You are Genius ano ba ang natapos mo?

Isang request pa Please!

Gusto ko mag search nman ako. Ex: pagmaginput ako sa txtbox nang "Monday lahat nang scheds ko in Monday i ddisplay sa datagrid or sa flexgrid...

Malapit ko na kasi matapos program ko, practice Thesis kasi ito nmin, Tulungan mo nman ako.. THanks John