(adsbygoogle = window.adsbygoogle || []).push({}); Step 1. you need an sql server i use the sql server for my site or either host it yourself i use to use whamp

Step 2. you need to set up a user account on the sql server, some web hosting ask you to make an account and assign it to a certain part of the server also theres should be somthing to do with allowed connections just put "%" in the box instead of an ip address withought the quotesand you need to create 3 columbs in the database do the same as below.

Name: userid
Type: int(10) unsigned

Name: username
Type: varchar(100)

Name: password
Type: char(32)

Step 3. once you have set up the database enter some details in the colum for e.g 1, myuser101, mypass101

Step 3a. download this dll You must login or register to view this content. and add
using MySql;
using MySql.Data;
using MySql.Data.MySqlClient;
thanks to Citadel for the reminder

Step 4. use this code in your tool put it on login button just change the details to your server.

    try

            {

                string myConnection = "datasource=Server_Here;port=3306;username=Username_Here;password=Password_Here;";

                MySqlConnection myConn = new MySqlConnection(myConnection);



                MySqlCommand selectcommand = new MySqlCommand("select * from Database_Name_Here.Table_Name_Here where username='" + this.username_txt.Text + "' and password='" + this.password_txt.Text + "' ;", myConn);





                MySqlDataReader myReader;

                myConn.Open();

                myReader = selectcommand.ExecuteReader();

                int count = 0;

                while (myReader.Read())

                {

                    count = count + 1;

                }

                if (count == 1)

                {

                    MessageBox.Show("Thank You for Loging in");

                    ConnectBut.Enabled = true;

                    CCAPIRB.Enabled = true;

                    TMapiRB.Enabled = true;

                    username_txt.Enabled = false;

                    password_txt.Enabled = false;

                    button1.Enabled = false;

                    NAA.Enabled = false;

                    

                }

                else if (count > 1)

                {

                    MessageBox.Show("Theres 2 Users with that username Please contact Your_Name_Here ...Access Denied");

                }

                else

                    MessageBox.Show("Username or Password is Not correct .. Please try Again!");



            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

Step 5. create 2 textboxes and change the name to username_txt and the other to password_txt

Also. if you want to press enter and it press the login button whilst on your password textbox then use this code

    private void password_txt_KeyPress(object sender, KeyPressEventArgs e)

        {

            if (e.KeyChar == (char)13)

            {

                this.button1.PerformClick();



            }

        }

Any questions just ask.

Suggest a good site(I would do free ones since most people won't pay for one )

They need the mysql dll too. You must login or register to view this content.
Pretty sure you'll need

using MySql;
using MySql.Data;
using MySql.Data.MySqlClient;

only problem is, is that all the free one's don't support remote access hence the need to pay you can make your tool login to a website though and check the webpage for the words "Log out" to comfirm they have logged in and thanks for reminding me ill add in the dll to the instructions

I played arround with C# / PHP for SQL Member Verrification.
It works on free hoster too.

I have release my simple Coding.



You can find all information in the description of the video.

Cheers ...

This. To test it, just use a quote char in one of those fields.
I suggst to lear some basis of PHP and code a server side, more secure.

Storing passwords and sensitive data is plain text is bad programming. Look into hashing passwords.