visual basic login using a database (SQL way)

[0Infected]

thanks just what i wanted

[enbunoverna]

That is an "optimal" video. =p

[Lucky7BoyPT]

Just want to leave my thanks

[Lucky7BoyPT]

Just want to leave my thanks

[abdulahmoh2]

really really Thank youuuuuuu

[edstone61n]

This video went viral on Ireland

[thekonny1]

how to password protect database ?

[97thethe]

if my forum's database uses encrypted passwords ?

[StevesRandomVideos]

Ive got a problem with the line "adaptor.Fill(dataset, "0")" It comes up with this error "{"Incorrect syntax near the keyword 'User'."}". Why!!! It doesnt in the video  :P Any help is appreciated.

[killpietri16]

Thanks, it worked! Keep up the good work!

- Also Nice song :3

[vryce13235]

You rock, I learned a lot from this and plan to check out your other vids. Thanks for making them!

[ashcresswell]

is there any way of making an administrator go to 1 form, and another user go to another??

[ashcresswell]

works perfect, thanks



[deafjackomonster]

@InfernoGamingTV Rise Against are amazing :|

[CFCPaddy]

Followed this and works perfect, I am comfortable enough with SQL so I modified/added some code and I can add and delete members no problems, when application is restarted, all new members that have been added are automatically deleted (database reset).

I don't understand how to create a create a dynamic database that keeps the changes. How can you do this i VB?

[SinceHigh]

how do i make it online ?

[WK010]

Music rox :D

Used to listen to it too ^^

[soukainasd]

i've this error msg (l'opearteur '>' n'est pas defini pour les types 'system.data.datarowcollection­' et 'integer') how can i fix it???

[deadkemo]

this is the answer to all of my problems! thanks for this wonderful tutorial! keep up the good work!

[CrimsonEyedCat]

Thank U so Much!!! (Like the Song, which one is it?)

[CrimsonEyedCat]

@CrimsonEyedCat Never mind x3 I just saw the name up above :D

[monaiz942]

heeeeeeeeeee

[monaiz942]

heeeeeeeeeee

[monaiz942]

asdfasdfasdf

[DCodeMast3r]

song? :P

[MusicStation4Life]

thx man its working!

[mechellemorano]

thanks!it really helps me a lot in my thesis! :)

[CodyJDV]

free vb.net e-book: /watch?v=jH8TWep8cBA

[DutchDude1984]

f*cking music



[deafjackomonster]

@DutchDude1984 Allright don't cry

[VBNetTutorialz]

@deafjackomonster Lol, i bet hese crying now :D

[DutchDude1984]

fucking music

[Kazaskater123]

omg. literally 1 hour of trying to convert all this to c# myself, then I read the message at the end lol

[Xboy15Hax]

first song: Rise Against - Savior

Second Song: Billy Talent - Red Flag

and thx for the tutor)

[DeviantDigi]

After messin with this for a bit. Its really not secure. for example: say test:123 is the stored account info. test:456 will also login.

[DeviantDigi]

Awesome tut bro, thanks alot. Much much better than the previous login code I was doing.

[Ashuavr]

Hi Thanks again...

Finally executed...!!!!!!:)

What helped me??

This nice Video + about 10 of these COMMENT PAGES!!! lol

[Ashuavr]

Hi thanks!!:)

[YoungPrototype]

Can you remake this with voice?

[QQ20034]

how do i search a database in this way?

[Guillemetalero123456]

If i'm using an access database, Am i need to change something?

[framboozle]

if i wanted to attach this onto another project, how would i do it? every time i hit debug the other project opens before the login screen(its just never shows up)

[kidnapper4all]

hay how did u get that string name?

from where did u copy that?

[trdjunkie]

Thanks a lot for this bro :)

Helped a lot

[anpascally]

Song name: Rise against - Savior

[ResidencialHebe]

Good work =D

[sarau255]

What the name of song?

[NeackoRox]

my login doesnt work it says error at code :

connection.Open()

it says error:

SQL expectation unhandles

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

[andresgvasquez]

I have this error (spanish) Sintaxis incorrecta cerca de '27503'.

Falta la comilla de cierre después de la cadena de caracteres ';'.

[cookie73942]

Hey i need some help. When i got to add a Server-based Database it says, This server version is not supported. Only servers up to Microsft SQL Server 2005 are supported. What can i do to fix this or is there anything i can do to fix this.

[Li0nSword]

@cookie73942 I got the same problem. Its because you have to install microsoft sql server 2005. But I cant seem to get mine set up because it keeps saying cannot connect to server and I don't know what to do from there.....

[gacululu]

It helped me so far. Thanks Dude! 

[FlaviusCamelias]

here gives me eror wen debug adaptor.Fill(dataset, " 0 ") <--- error Incorrect syntax near the keyword 'User'.

[sharp0919]

thanks a lot! ur so great. can u make a video that using ms access thks!

[SemLemSushi]

will other people be able to login if they download this on their computer and i add something new to the database? will it update it on their computer?

[newyork542]

7:43

[stronger1979]

i have this error: Valor de la clave 'attachdbfilename' no válido.

[Stopmovies]

can you please reupload the source . Thanks

[cht9178]

can any1 tell which music is playing on background ? Thx.

[Stopmovies]

@cht9178 Rise Against - Savior

[cht9178]

@Stopmovies Thanks for your kindness.

[jheb54]

tnx nc tut

[weather199]

A thanks man you have save the day :)

[mayokaaa]

after am runing the program am having error on adaptor.select command = command

[TutorialsVideosS]

@DickRise rise against savior

[Dutchtopia]

links dont work!

[maxter1999]

might make a vid on an advanced login system create account ranks login database and control panel i have a few versions newest onee is just 5 mins ago Gracie Rebellion Manager lets me add members tio my groups and remove change thier ranks etc(Gracie is a lil overpowered fag)

[jeffdobbelf]

thanks, this really helped

now im trying to figure out how people can add themselves to the database through a "create account" button :p

[deafjackomonster]

@jeffdobbelf Check the other videos I have ;)

[AmericaDude92]

Can other people connect to my database on there computers with this code? I'm new to VB. I understand the basic principle, and I know sql because Ive used it in PHP; however it's used quite differently with Visual Basic. That being the case, I need to understand how I would get someone to be able to log into a program when i add the accounts manually in my own database, then they log in with that information based on the tables in my own database. Message me please if you can. Thanks -AD92 :)

[codeofmichael]

very nice tutorial,,, like your music... it keeps me rockin... good job...

[maxter1999]

command.CommandText = "SELECT * FROM [User] WHERE (username='" + TextBox1.Text + "')AND (password='" + TextBox2.Text + "');"

too me bout a hour to fuigre this out considering i dont know sql

[deafjackomonster]

@maxter1999 Il post that up on the description then :( Sorry it took so long. However I bet you lernt SQL ;)

[maxter1999]

@deafjackomonster i didnt i just looked up a bit of sql i might learn it thou but it dosent seem like my kinda laugage :)

[deafjackomonster]

@maxter1999 SQL's like politics, you ether love it or hate it, but you need to know about it ;)

[Anggiclassicerz]

tx alot! Can you help me with this? =.i made 1 and i enter 2 ID there .. and i share my program already and 5 people download it., and i want to add another user .. so can i add another user , but also automaticly added to my program that the 5 people downloaded ?

-sorry for bad english

[maxter1999]

@Anggiclassicerz that would be a auto-patcher and it dosent look like you built one in your app so you would have to redeploy it if you want a create account system remake your program with deaf's easier tut's that have a create account dont try to mix this hard 1 and his create account it comes out wit an error i know this cause i learned sql bout 5 mins ago and im a vb master like deafjackomonster.

[hardikvd89]

It's really nice... I was in search of this tutorial from a long time....

Thank you very much...

[sarthak000]

u r awesome.. made my day dude:-)

[deafjackomonster]

@sarthak000 What I like to hear :P

[vikingo212121]

maestroo!!!! gracias

[johnluchomono]

@vikingo212121 TONTO HUEÓN!!! (seguro tienes que traducir con google para entender algo de lo que dice aquí...saco de huevas!!!)

[vikingo212121]

@johnluchomono kallate hijo la loka kulia ... ella la gringa edionda a raja ... xupala konxetumare

[NMblindBBC]

how to make an login system what send me than the info on email or what ever than i can know than pw and login

[gaston22]

good tutorial, maybe it would be easier to use linq...

[deafjackomonster]

@gaston22 What is ling? I have heard of it yet never needed to use it yet have heard good things about it.

[gaston22]

@deafjackomonster LINQ was introduced i believe in .net 3.5, you save time, to show you an example, you could do something like

Dim query = from items in database.table select items

datagridview1.datasource = query

there are a few steps that you need to take before that

you may want to take a look at this video /watch?v=IkgozlbfKmY

[norway172]

My VB won't accept the Connection line at 3:19

I'm using VB Express 2010, it all worked fine until I got to that line, then it gives me some syntax Error.

Please help?

Thank you

[OfsSoftwarez]

@norway172 Your Problem is That At The begining of the vid he made a mistake "Dim connection As New SqlClient.SqlConnection" at the top and all the connection has to be the same check if they all are the same becuse if u copyed from vid didnt really show him fixing the mistake hope i helped.

[eltogoRishi]

Good tuto

[lavienja]

I Want Revenge! bit . ly/jerku

[manyak0]

No Comment. Thanx

[HebeSHE63]

hi. if i want to use this tutorial to create a New User function, what do i need to do?

Aside from adding a button :D

[mollyer77]

hello!

can you tell me what band plays this song in this video?

[deafjackomonster]

@FlentMan Nothing :S

[networking26]

Awsome video, thanks

I can use this in my application when i deploy it to the web

I'm looking forward to seeing some more videos from you

[supershadow70]

i can create a database cracker?

[MrEndur]

Songs ?

[Plubliii]

@MrEndur Rise Against - Savior

[MrEndur]

@Plubliii k thx :)

[netxcess]

exactly what i was looking for..thx a lot :D

[MrAthos909]

thanks, noice lil tutorial thou it may be worth commenting the code so people know what certain lines do, Thanks

[smcorrea]

I get an error at adaptor.Fill(dataset, "0") Syntax Error, help :s

[Vb2008Tutorials]

@smcorrea If you didn't already found out, I had the same problem but I was able of correcting it. You surely got an error there : /// command.CommandText = "SELECT * FROM [User] WHERE Username= '" & TextBox1.Text & "'AND Password='" & TextBox2.Text & "';" /// Just copy and paste this line because with me it's working :)

Hope I will help

[smcorrea]

@Vb2008Tutorials I also found out that, but i really appreciate that you took your time to reply to my comment. Thanks ;]

[DieselUofA]

@smcorrea Me too

[pcteacher55]

password part "*" shows that it had been marked, while the password would be great.

[ArabianCracker]

Cool i will be surfing your channel 4sure

thank you

Peace!

[jackpotsvr]

Is this online or just offline database?

[deafjackomonster]

Local database

[OnceLiberated]

dude please do everyone a big favor and make a tutorial for adding things to the database

[ax31rebound]

What book have you used or where can I get more info about the connection to the server(.mdf ) and how to retrieve data from it?

[RichToms09]

I did all that you have done on this video but I cannot get a connection option at 3:19 any other way I could do it?

[Agung2001]

for TINNEDtomatos and for all have the same problem,,

i think you must remake your application to use this tutorial,, because i have the same problem,, and i remake my application,, and its works greate,,

thx deafjackomonster for the tutor,,

[abliilcley]

This was really helpful thanks.

could you show me how to add a new username/password to the database?

thanks

[imboor3d]

fantastic guide, thankyou so much

Helped me with my ICT coursework

[deafjackomonster]

What I like to hear :P

[paperboy204]

dude what version of SQL and Visual Basic did ya use? so i can start learning new versions.... coz im still using MS Access and VB6... this vid is efing clear as water and its freakin sick dude... 5 stars...

[icyshadow0]

It's Microsoft SQL Server 2005 and Visual Studio 2008, SQL Server 2005 is included with Visual Studio 2008.

[superawesomesuperkid]

addaptor.Fill(dataset, "0") Dim count As Integer = data.Tables(0).Rows.Count

[NorthAmericaHG]

Please help me 8:26 adaptor.Fill(dataset, "0")

error

Incorrect syntax near '='. Unclosed quotation mark after the character string ''.

[marcosmast]

Here:

command.Connection = Connection adaptor.SelectCommand = command Dim ouint = Dataset.Tables(0).Rows.Count  If ouint = 0 Then

also make sure you got End if in the end!

[vallismall]

adapter.fill(dataset, "0") i get error

Incorrect syntax near ')'.

[timmy16041997]

@vallismall

i got the same prob.

[bernard72]

i need the create account form asap cause my project is counting down in 17 days can?Much appreciate and Thanks

[techgeek93]

um.... im assuming this is for school. Why don't you figure it out your self instead of having a tutorial on it, when all you'll do is copy and paste that code, and not learn anything

[bernard72]

hey deafjackomonster nice application you have here and by the way i wanna ask can you make a tutorial on how to make a form that can create username and password and through that form it can save inside the data base

[deafjackomonster]

SQL insert. Will make a tut soon. Subscribe and expect one soon

[snwspeckle]

Can you convert this into C#? Would be very helpful.

[deafjackomonster]

Wait there is one. Its on my profile "C# login database"

[Ven732]

PLEASEEEEEEEEE

What Is The Song From 7:00 To The End ?

HELP MEEEE

btw nice vid ^_^

[hecmame]

Rise Against Savoir

[goplayergo]

Billie Talent - Red Flag

[Jusikid]

red flag

[iware1]

its called iware and you will be able to download music and videos you will also be able to play your own videos and music. i will have to charge for the online content but that because on copyright laws. sorry

[iware1]

thanks alot this was realy help full. Could you please do one about a acces database please.

o and can you please check out my software i am planing on making in visual basic 2008 and tell me what you think

[deafjackomonster]

@iware1 ok will keep it in mind, what softwares this

[pontaxxr]

i dont understand a can't dedubbing becuse connection are wring help me what did i do wring

[mfi29m85]

only u can usin this ptg? i will ake tht my frends 2 get using my login pls help ty

[augis1996]

How do I hide the password like this *********?

[VincentLaw9]

Thats easy, go to TextBox Properties and serch for PasswordChar, then set it to * or the character you wish to.

[T0uchH4xT]

Click on your textbox, go to the settings and set * for the filter.

[Jacob332me]

Nice Music, But not what I was looking for.

[Jacob332me]

BTW: 5 stars (Cause You do explain it well)

You might have to remake this for VB 2008. It's a little different.

[azs890530]

hermmmm next time maybe u can replace that useless song with u voice to make it clear.but anyway GOOD

[deafjackomonster]

aint got a good mic

[LetsGouTubein]

you should search Youtube for "build your own mic" lolz

[corvettezack]

so if i were to make a program that has the same login system that you made and there were no users, and i released the program, and if someone wated to be registerd, if i added his pw and user in the database would it occur to the already released program, so he could log in, PLEASE REPLY BACK!!!

[ethien007]

Can u teamview me... Please i need your help real bad!

[deafjackomonster]

what with? PM me

[ethien007]

Can i use it with an already made website database?

[deafjackomonster]

if you can gain acsess to a remote database on your webserver yes you can

[yendras]

wow, music rulez ;-)

[ProClub0wns]

How would i make a account creator?

[SrFons]

mine says that the "keyword not supported"

its the "provider" in my connection string

please answer me,anyone i really need help

[FurryMuf]

Anyone know the song?

[deafjackomonster]

yer i do haha, saviour by rise agenst

[L2DragonHunter]

Checkout my MYSQL Brute Force

watch?v=dMIjDgWbF98

[TINNEDtomatos]

HI, great video

but everytime i try and debug i get an error with this statement adaptor.Fill(dataset, "0")

Incorrect syntax near ','.

Please help me cause i really like your video...

[mothman1999]

Hi, heaps cool video. helped me heaps. one question: I need a method to register a new person from my login form. basically it will have a little register button down the bottom. I would like to know if there is a way to code it so that whatever is entered in the username box will become a new username, and same with the password. If this makes sense, please get back to me. 5/5 for your video btw :)

[deafjackomonster]

user registration involves modifying the SQL to insert, subscribe and expect a video soon

[robsandan]

Thank you very much. It was very helpfull!

[TheDangerousRed]

Very good, LOVE THE TUTORIAL. And the song. You are my hero!

Btw possible to do with website databases?

[sputtnikk11]

I'm getting an error on this line: adaptor.Fill(dataset, "0")

Incorrect syntax near ')'

some help would be sooo great! :)

thanks! :D

[deafjackomonster]

change your () in the SQL string to [ ] around the table declaration

Hi mate,

thanks for the vid, great quality and nice songs. I coded this app in a web aplication form, and everything is fine apart from an error the 10th line in which it says: connection.Open()

when I debug the app I get the following error:

Request for the permission of type 'System.Data.SqlClient.SqlClie­ntPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e08­9' failed.

thanks :)