VB6 Advance login system w/ database creation and SQL command text

[tagashi9]

your are all stupid,, it is his theory of programming,, just shut up anf listen to this basic programming,,, its your own decission on how you command your program,, so dont expect you sour port

[malexrm]

Adodc1.RecordSource ="select*fromloginwhereusernam­e= '" +txt_user.Text+ "'"

Adodc1.Refresh

If (Adodc1.Recordset.EOF =False)Then If (txt_contrase.Text=Adodc1.Reco­rdset.Fields("Contraseña"))The­n MsgBox"IngresoCorrecto"

 Unload Me frm_time.Show Else MsgBox"ContraseñaIncorrecta" txt_user.Text = "" txt_contrase.Text = "" txt_user.SetFocus End If Else MsgBox "Usuario Incorrecto" txt_user.Text = "" txt_contrase.Text = "" txt_user.SetFocus End If

End Sub

[malexrm]

@malexrm por favor @lloydangelo22 me lanza error.. ayuda pon el codigo para descargarlo gracias...

pease @lloydangelo22 release me mistake ... .. help put the code to download thanks ...

21-01-12

[malexrm]

@malexrm encontre el codigo...

((ht--tp:--//youtu.be/MQNo0bMf­TnY))

[bassalegboii]

lloydangelo22 is a virgin XD

[taekagipot]

naka log in ako sa wakas!!!! hahaha

tnxx

[vAMFiXED]

wew. 

[mrSoulTwin01]

Thanks dude makakatulong to sa pag aaral ko ^_^

[gabvine09]

MARAMING MARAMING SALAMT~!!!!THANK YOU THANK YOU!!!!!!!

ngaun alam ko na kung panu magchange password..hehe

un n lng kc problema o,kya thnx thnx tlaga ng mademe....mwuahhhhhhh!! :))))

[painofakatsuki22]

boss salamat naka tulong sa akin

[gerxpaul28]

nc malupet! KEPT IT UP DAMIHAN MO PA NAKAKATULONG KA!!!

[blacktop26]

sir sa visual basic nmn po Pagawa tnx (;



[RentawmarshMALLOw]

make*

[RentawmarshMALLOw]

please name more tutorial videos..masnagegets ko gumawa ng program pagnakikita ko yung process..hirap ng dictation sa class..hinde ko nagegets hahahaha...Thank you ulit ^_^

[lloydangelo22]

@RentawmarshMALLOw pasensya na busy ^_^ ako eh dnako makakagawa ng tutorial ehh next time pag may time

[RentawmarshMALLOw]

I just want to say thank you so much for this..you saved my life ^_^

[marlon55555marlon]

panu iconnect ang datareport sa database?pls reply asap..tnx+

[incako071810]

pre salamat sa login tutorial ,, nkuha ko xia ng malinaw,,

[incako071810]

pre salamat sa login tutorial ,, nkuha ko xia ng malinaw,,

[AzlanNohara]

what is the name of the first song on the video?

[Inuyashanna]

ibibgay din yung code

[tdxk800i]

can i login set A then form 2, another set B then login to form3 ? can i?

[gerxpaul28]

nc ! @[184559744940365:2:SNA DUMAME PA ANG MAGUPLOAD NG VB PROGRAMM!! SPREAD THE IDEA!] .

[gerxpaul28]

nc ! @[184559744940365:2:SNA DUMAME PA ANG MAGUPLOAD NG VB PROGRAMM!! SPREAD THE IDEA!]

[kyle5969]

sana di po kau magsawa sa pag post ng video

[kyle5969]

thank much mu naintindihan ko ung presentation mu..

[yemah11]

d best ka!! tinulungan m ko sa case study namin!!salamaaaaaaaaaaaat!! :))))

[NaShishDre]

tnx dre ! laking tulong nito

[MVPblackmamba24]

ikaw na, da best ka :)

[keepr0ck]

boss panu ung lagyan mo ng time pagka login

tnx

[technoMeFy]

I dont have ado data control!

[TheFrstblood]

the best...!! mkaka2long pu yan sakin sa pagpasok ko dis coming school year!!

^_^

[Drakod9]

At first im like WTF is he saying?



[bd39hp]

thanks bro :) i did it....gr8 job...

[Kiyunnkiyo]

i cant log in

[edgarconan]

tnx database thesis nmn using vb .. :D

[Mrreniel24]

Tnx din.. :)

[OHWELLDEE]

nice program, vry useful i2 s mga gumgwa ng thesis! keep it up,

[odinerson]

hanep, buti nalang meron to, salamat pare, magsusubcibe ako

salamat sa inyo video

[seniorito15]

nice TnkKS! tanga!

[quimisle]

thank you very much for sharing some knowledge. OMG. very very thankful! :D

[mhieche14]

thank you very much for this video, you definitely saved me from failing in my thesis...

[PiaIsabel09]

UGH! I'm glad I found this tutorial! THANKS A LOT!! :)

[quimisle]

Hindi po nag work.

May error po sa adodc1.refresh sa command1... pano po to.

pasagot naman po please :(

[quimisle]

may error po sa adodc1.refresh. pano po yun?!!

[jaytigerdtg]

mga kaibigan... pano ba sa databse ung pag mag aad ka madedetect kung meron nang kaparehas ung word na un na naka save na sa databae mo?

[MegaBadaboom]

ou nga may error dun sa Adodc1.Refresh

[nophecotson]

kaya mo po bang gamawa ng library system ?

[JUD861994]

bakit ayaw po magrefresh ng adodc1?.. nageerror...

[r00if]

Tnx for making this tutorial

[Johnz05]

ganito codings ko sa delete..

if msgbox("Are you sure you want to delete this record?.",vbyesno,"Delte")=vby­es then adodc1.recordset.delete

msgbox"Deleted",vbinformation,­"Success"

else

adodc1.refresh

endif

nkalimutan ko na lahat ng codings..e2 lng natandaan ko sa adodc...huhuhuuh

[Johnz05]

ahh ganun ba...hehehe.....tnk u pow...salamat..kc akin isa lng man...^^..paturo ba ulit ung may maglabas ng msgbox" Username already exist!." 2 years na kc aq nag stop sa programming...huuuhu

[Johnz05]

aw... bkit dalawa gamit ng adodc mo?diba pde rin isa lng?.....

[lloydangelo22]

@Johnz05 first adodc is for SQL command 2nd is for the record

[rickyb0i]

kuya ask lang po pwede ko rin ba itong gawin sa VBnet?

kasi yun po gagamitin ko ngayon para sa thesis ko.

[cloudsky0103]

..pwde po buh hingin yung code nyo poh.. tnx poh..

eh messge nyo na lang poh..(+_+)

[mourice12]

salamat dre.

[Clenclen1]

tnx for your tutorial

[bolotoy321]

On Error Resume Next

AdoConLogin.RecordSource = "select * from Login where Username = '" + txtUsername.Text + "'"

AdoConLogin.Refresh

If (AdoConLogin.Recordset.EOF = False) Then If (txtPassword.Text = AdoConLogin.Recordset.Fields("­Password")) Then Unload Me MainFrm.Show MsgBox "You Have Successfully Logged In!", vbInformation + vbOKOnly, "Welcome!" Else MsgBox "Invalid Password, Please Put Valid Password!"

end if

sabi po invalid password error help po

[bolotoy321]

@bolotoy321 i know the error pala: ung

If (txtPassword.Text = AdoConLogin.Recordset.Fields(" Password"))

kelangan tangalin ung ( " " ) kasi indi mabasa sa system na string kaya pag inalis ko ung " " thingy gumana... anyway thank you pala sa tutorial mo... meron na akong naisip na ideya.. thnx tlga....

[vaine0702]

tnx sa vid mo my project na ko....

tnx a lot...

[mArkaRThur12]

Gawa ka ulit ng tutorial yung may boses. Tnx

[jobert1922]

panu poh lalagyan after i log in ung account ng student informaion agad ang lalabas..ty poh..

[lloydangelo22]

@jobert1922 datareport ba? yung iprint yung mga nasa database? gagawa ako ng tutorial if d nako tinatamad... haha

pero kung information lang gawa ka ng isa pang form tapos lagyan mo ng textbox

kada field na gusto mo makita tapos ilink mo na yun sa database mo...

[mArkaRThur12]

hello, pano po mag lagay ng limit sa database? example sa enrollment na program, gusto kong 500 students lang ang pweding ma.enroll tpos pag na.reach na nya yung 500, hndi mag aaccept ng data yung database tsaka my msgbox na lalabs "Enrollment is full"

[lloydangelo22]

@mArkaRThur12 d ko pa sya nagagawa pero for my method need mo gumawa ng field sa mdb "ID" kada save mo nag +1 so gagawaan mo nlng sa ng if statement

if adodc.recordset.field("ID") = 500 then

msbox "Enrollment is full"

else

adodc.recordset.addnew

..........

endif

[starcatcher164]

hi po, ask ko lang po kung pano maglalabas ng message kung isang beses lang dapat iinput sa record and isang field. Tulad po sa Student number, primary key po yun at dapat unique. Palalabasin yung msg box saying "Student number already exist"?

[lloydangelo22]

@starcatcher164

ang code na gagawin mo is

If (Adodc1.Recordset.EOF = True) Then msgbox "Student number already exist"

tapos clear mo ung mga textbox nya gaya ng ginawa ko sa login button ko parang ganun lng if statement

[starcatcher164]

@lloydangelo22 salamat pu

[mArkaRThur12]

hey are you filipino?

[lloydangelo22]

@mArkaRThur12 yup filipino me why?

[lloydangelo22]

Sorry Guys i forgot to show cursor when start recording....