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

Поділитися
Вставка
  • Опубліковано 15 січ 2025

КОМЕНТАРІ • 168

  • @martinomantovani5594
    @martinomantovani5594 6 років тому +1

    Thank you so much for the help!

    • @foxlearn
      @foxlearn  6 років тому

      You're welcome. Thank you !

  • @arsalanamin8474
    @arsalanamin8474 6 років тому

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

    • @foxlearn
      @foxlearn  6 років тому

      Thank you so much !

  • @ermalspahiu2579
    @ermalspahiu2579 8 років тому

    Thank you,It worked perfectly .

    • @foxlearn
      @foxlearn  8 років тому

      That's great. Thank you !

  • @toantruong8750
    @toantruong8750 8 років тому

    Very good, thanks so much

    • @foxlearn
      @foxlearn  8 років тому

      +Toàn Trương Thanks :)

  • @manudhanjal3365
    @manudhanjal3365 7 років тому

    this is very helpful

  • @senadhaw2652
    @senadhaw2652 4 роки тому

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

    • @senadhaw2652
      @senadhaw2652 4 роки тому

      why is this coming

    • @foxlearn
      @foxlearn  4 роки тому

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

  • @k_peter_001
    @k_peter_001 8 років тому

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

    • @foxlearn
      @foxlearn  8 років тому

      Hi, I've uploaded you can view ua-cam.com/video/4ToxRR-zlKs/v-deo.html . thanks

  • @trienvovantai7763
    @trienvovantai7763 6 років тому

    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
      @foxlearn  6 років тому

      You can view this video ua-cam.com/video/4ToxRR-zlKs/v-deo.html . Thank you !

  • @SKins34
    @SKins34 8 років тому

    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
      @foxlearn  8 років тому

      Hi, You can view this video: ua-cam.com/video/4ToxRR-zlKs/v-deo.html (Create Login Window With User Authentication) Thanks

    • @SKins34
      @SKins34 8 років тому

      Thanks :)

  • @CallumG450
    @CallumG450 8 років тому

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

    • @foxlearn
      @foxlearn  8 років тому

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

  • @ductptran1598
    @ductptran1598 3 роки тому

    good

  • @ondrej.mahdalik
    @ondrej.mahdalik 8 років тому

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

    • @foxlearn
      @foxlearn  8 років тому

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

    • @ondrej.mahdalik
      @ondrej.mahdalik 8 років тому

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

  • @jandevincabahug
    @jandevincabahug 7 років тому

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

    • @foxlearn
      @foxlearn  7 років тому

      Hi, What's your email? Thank you

  • @erectorsam4186
    @erectorsam4186 6 років тому

    thanks thanks thanks thanks .

  • @danish9742
    @danish9742 7 років тому

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

    • @foxlearn
      @foxlearn  7 років тому +1

      Hi, You can view this video ua-cam.com/video/NvetzDZgjWI/v-deo.html to know how to do that. Thank you

    • @danish9742
      @danish9742 7 років тому

      Thank you. It helped me

  • @hassanjaved2227
    @hassanjaved2227 8 років тому

    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
      @foxlearn  8 років тому +1

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

    • @Hejhouyou
      @Hejhouyou 8 років тому

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

    • @foxlearn
      @foxlearn  8 років тому

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

    • @hassanjaved2227
      @hassanjaved2227 8 років тому

      It worked for me.
      Bundle of thanks.

  • @catalinpresneanu1879
    @catalinpresneanu1879 7 років тому

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

    • @foxlearn
      @foxlearn  7 років тому

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

  • @turnerztech935
    @turnerztech935 8 років тому

    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
      @rebugservices4992 8 років тому

      Are you putting the code right?

    • @turnerztech935
      @turnerztech935 8 років тому

      +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
      @rebugservices4992 8 років тому

      i couldnt create the sql form ;(

  • @thesuberashidedu1208
    @thesuberashidedu1208 7 років тому

    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
      @foxlearn  7 років тому

      Hi, What's your email? thank you

    • @thesuberashidedu1208
      @thesuberashidedu1208 7 років тому

      weaktype00@gmail.com Thanks maam :) :) I'm so Excited :)

  • @robiesuarez7730
    @robiesuarez7730 5 років тому

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

    • @foxlearn
      @foxlearn  5 років тому

      Please check your code again. i think you miss something

  • @Lars51
    @Lars51 6 років тому

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

    • @foxlearn
      @foxlearn  6 років тому +1

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

  • @alaynarajput3062
    @alaynarajput3062 7 років тому

    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

  • @obaidrehman1
    @obaidrehman1 8 років тому

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

    • @foxlearn
      @foxlearn  8 років тому

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

    • @obaidrehman1
      @obaidrehman1 8 років тому

      Thanks..

  • @CristiDjful
    @CristiDjful 7 років тому

    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
      @foxlearn  7 років тому

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

  • @vincenteinosas9514
    @vincenteinosas9514 7 років тому

    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

  • @eddyquintero91
    @eddyquintero91 8 років тому

    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.

  • @BugsbunnyEh
    @BugsbunnyEh 8 років тому

    great video too fast when u click with mouse

  • @joshoaacorin7193
    @joshoaacorin7193 8 років тому

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

    • @foxlearn
      @foxlearn  8 років тому

      Hi, What's your email? thanks

    • @joshoaacorin7193
      @joshoaacorin7193 8 років тому

      dyoshuwa29@gmail.com
      Thank you so much!

    • @foxlearn
      @foxlearn  8 років тому

      Sent. Thanks a lot :)

  • @MyChameera
    @MyChameera 7 років тому

    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);
    }

  • @jandevincabahug
    @jandevincabahug 7 років тому

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

    • @foxlearn
      @foxlearn  7 років тому

      Hi, What's your email? thank you

  • @gabrielortiz4506
    @gabrielortiz4506 6 років тому

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