C# Application - How to create a Login Form with SQL Server | FoxLearn

[@martinomantovani5594]

Thank you so much for the help!

[@foxlearn]

You're welcome. Thank you !

[@ermalspahiu2579]

Thank you,It worked perfectly .

[@foxlearn]

That's great. Thank you !

[@SKins34]

Thank you very much for tis tutorial...Can i know how to add multiple users to tis login form and how to make the login form and the database open at startup if its not too much of trouble 2 u??

[@foxlearn]

Hi, You can view this video: kzbin.info/www/bejne/aoXSqYWIYt-fgdU (Create Login Window With User Authentication) Thanks

[@SKins34]

Thanks :)

[@vincenteinosas9514]

suggested put a exit button. and a prevent system like when have already 3 attempts the system will shutdown and in security purpose add a when you type your password your system will ask caps lock and numbers to have a high security and add a new button to create a new user thanks sir/madam

[@trienvovantai7763]

Excuse me, but i have 1 more column in database named role, how can i get its value. Because i want to login with 2 role (admin and user ). Thank you so much

[@foxlearn]

You can view this video kzbin.info/www/bejne/aoXSqYWIYt-fgdU . Thank you !

[@arsalanamin8474]

you're amazing............thanks

[@foxlearn]

Thank you so much !

[@toantruong8750]

Very good, thanks so much

[@foxlearn]

+Toàn Trương Thanks :)

[@manudhanjal3365]

this is very helpful

[@thesuberashidedu1208]

This save my day :) Thanks maam :) can you please send the code maam ? just for my reference :) Thanks maam this help me a lot :)

[@foxlearn]

Hi, What's your email? thank you

[@thesuberashidedu1208]

[e-mail] Thanks maam :) :) I'm so Excited :)

[@k_peter_001]

Thank You your tutorials! Very helpful!! Could you create a login with windows username authentication?

[@foxlearn]

Hi, I've uploaded you can view kzbin.info/www/bejne/aoXSqYWIYt-fgdU . thanks

[@senadhaw2652]

Error CS0246 The type or namespace name 'TestEntities' could not be found (are you missing a using directive or an assembly reference?)

[@senadhaw2652]

why is this coming

[@foxlearn]

Add an ADO.NET Entity Data Model, then enter name Test. You should see all don't skip if you want to lose something

[@CallumG450]

How would you insert data into the table, like for registering a user?

[@foxlearn]

OK. Thank you for your suggestion. I'll make soon

[@catalinpresneanu1879]

can you make a tutorial with register form with sql server , please ?

[@foxlearn]

OK. Thank you for your suggestion. I'll make soon

[@jandevincabahug]

Hi could you please send to me the whole program? Excluded the SQL Querry. Thanks a lot.

[@foxlearn]

Hi, What's your email? Thank you

[@Lars51]

Nice Video but by me TestEntities doesn't exist can you help me

[@foxlearn]

You should create a model, then you can enter with name TestEntites

[@alaynarajput3062]

System.Data.SqlClient.SqlException: 'A connection was successfully established with the server, but then an error occurred during the login process. error: 0 - No process is on the other end plz help me how to solve this

[@ductptran1598]

good

[@ductptran1598]

what is code process

[@erectorsam4186]

thanks thanks thanks thanks .

[@danish9742]

What to do if i want to open a new form on successful login?

[@foxlearn]

Hi, You can view this video kzbin.info/www/bejne/hKfIpa16j8ydjas to know how to do that. Thank you

[@danish9742]

Thank you. It helped me

[@turnerztech935]

hi thank you for this tut, i am having a problem it keeps saying username and password is incorrect and i'm not sure what i need to add where you put the comment. please help

[@rebugservices4992]

Are you putting the code right?

[@turnerztech935]

+RebugServices I believe so I don't have any errors but in the video he has a comment about putting some info in n I dint know what that bit is

[@rebugservices4992]

i couldnt create the sql form ;(

[@ondrej.mahdalik]

What means the 'o' in the 'query'? It doesn't work for me with the 'o' value.

[@foxlearn]

+Ondřej Mahdalík Hi, o is a variable. You need to include System.Data.Linq namesapce. Thanks

[@ondrej.mahdalik]

+Fox Learn I didn't noticed it. Thanks much.

[@robiesuarez7730]

but by me KeyChar doesn't exist can you help me. Thank you

[@foxlearn]

Please check your code again. i think you miss something

[@obaidrehman1]

if (e.KeyChar==(char)13) txtpassword.Focus(); Can u please explain this section to me...

[@foxlearn]

+Mudassir Rehman Hi, if (e.KeyChar==(char)13) using to check enter key press. Thanks

[@obaidrehman1]

Thanks..

[@hassanjaved2227]

Hi can you please help me I am getting error in this syntax on test.Users the error appears when i type in users . var query = from o in test.Users Please help me thanks.

[@foxlearn]

Hi, You need to add system.data.linq namespace. Thanks

[@Hejhouyou]

I have this problem aswell and it didn't fix the issue.

[@foxlearn]

Hi, What's your problem ? Can you take a screenshot and description your problem ? Thanks

[@hassanjaved2227]

It worked for me. Bundle of thanks.

[@BugsbunnyEh]

great video too fast when u click with mouse

[@foxlearn]

Thank you !

[@CristiDjful]

This error occurs CS0019 Operator '&&' cannot be applied to operands of type 'string' and 'bool' WindowsFormsApplication1 E:\Obiecte\Programarea vizuala\14.03.2017 - pentru acasa\WindowsFormsApplication1\WindowsFormsApplication1\Form1.cs 55 Active What to do?

[@foxlearn]

Hi, Please check your conditional operator again with data field types

[@eddyquintero91]

SALUDOS DESDE REP. DOM SOLUCIONASTE LO DE LA INYECCION SQL YA QUE SI PONES ESTO EN TU USUARIO Y CONTRASEÑA PASA (' or 1=1 or "=') SINO ES ASI TE INVITO A PASAR POR MI CANAL YO LO SOLUCIONE.

[@joshoaacorin7193]

Hello, can you please send me the source code. Thank you

[@foxlearn]

Hi, What's your email? thanks

[@joshoaacorin7193]

[e-mail] Thank you so much!

[@foxlearn]

Sent. Thanks a lot :)

[@MyChameera]

string connetionString = null; SqlConnection connection; SqlCommand command; string sql = null; SqlDataReader dataReader; connetionString = "Data Source=.;Initial Catalog=chameeraa;User ID=chamee;Password=123"; sql = "delete from data where name='" + dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString() + "'"; connection = new SqlConnection(connetionString); try { connection.Open(); command = new SqlCommand(sql, connection); // MessageBox.Show(sql); dataReader = command.ExecuteReader(); MessageBox.Show("Success Fully Deleted"); clear(); dataReader.Close(); command.Dispose(); connection.Close(); data(); } catch (Exception ex) { MessageBox.Show(ex.Message); }

[@foxlearn]

Thanks

[@jandevincabahug]

Hi could you please send to me the whole program? Excluded the SQL Querry. Thanks a lot.

[@foxlearn]

Hi, What's your email? thank you

[@gabrielortiz4506]

Hello, can you please send me the source code. Thank you