MySQL Login & Register Form System in C# Tutorial

Hey, I have made a program in c# with MaterialSkin template and I made a classic WinForm app, in Winform the code is working, but in Materialskin with the same code it isnt. Its popping some kind of message like:System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary! pls help 🙂

ALWAYS CANT REGISTER

System.ArgumentException

HResult=0x80070057

Nachricht = Option not supported.

Parametername: $server

Quelle = MySql.Data

Stapelüberwachung:

bei MySql.Data.MySqlClient.MySqlBaseConnectionStringBuilder.GetOption(String key)

bei MySql.Data.MySqlClient.MySqlConnectionStringBuilder.set_Item(String keyword, Object value)

bei System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)

bei MySql.Data.MySqlClient.MySqlBaseConnectionStringBuilder..ctor(String connStr, Boolean isXProtocol)

bei MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value)

bei MySql.Data.MySqlClient.MySqlConnection..ctor(String connectionString)

bei WindowsFormsApp1.Form1..ctor() in C:UsersthisisourcereposWindowsFormsApp1WindowsFormsApp1Form1.cs: Zeile32

bei WindowsFormsApp1.Program.Main() in C:UsersthisisourcereposWindowsFormsApp1WindowsFormsApp1Program.cs: Zeile19

error in conn.Close();

return false;

never hardcore the connection strings, except for demo purposes.

does anyone have the source code?

how to put the values in array?

I LOVE YOU!!

Error with ex.Number

before return true/false, you should make conn.Close();
it's reason to make error

Hey! 2018 here and your code is still good 🙂 Well , that and except 1 thing. I needed to add VALUE 1 or 2 into your code at the string query ( depending on the user id in the table ) to make it work to login or register. I am using an external database, but I don't think that's the problem. The idea is that the mysql does not know the user id , and even if the user/pass is correct, it would not let me login with an empty VALUE for 'id'. So , any idea to .. fix this to make it work properly ? Thanks!

I cant connect to the database ?

dude im sorry cause i new to this things. i have a textbox i named "MainTextBox" like ur username textbox. Should i change the "string user = tbUser.Text"? into what? thx for help.

Thanks, this help me a lot with my homework!

i have problem with conn and constring … the debug doesn't running because of that please help me

How do I control that a user is not connected to 2 computers at the same time?

Thank you so much! I've been searching for this 2 weeks!!! You are the best

"user has not been created" please Help

Thank u so much!

SOURCE PLZ

You people will definitely find it useful. Here I have shown that how to use INSERT command of DML in C#.
https://youtu.be/U4DQNNRs8rM

SO MANY ERORS. I HATE THIS UPLOAD A CODE FOR ONCE IN YOUR LIFETIME!!!

every time I try to login I get my name then has not been created.

thnk u very much

How can I make the password encrypted in the database?