[Help]VIP System

[Weezz]

First i want u guys to know im just a beginer about c# and stuff...
Second, u will notice that im not so good about english typing >.<

ive coded a LOTF source and made my own custom server

Now im developing a VIP system. i made many things work but theres still something i couldnt code then i came to ask for help.

Definition:i want to make a form connected to db for VIP member login and get the server upgrades and so on.

im working with my friend but we got some troubles with the code
all we need is get the form connected to DB and indentify the ids and passes

theres the coe we made:

string User = "";
                string Pass = "";
                MySqlCommand Command = new MySqlCommand("SELECT * From `UserIds` SET `Pass` = '" + Pass + "' WHERE `User` = '" + User + "'", DataBase.NewConnection);
                Command.ExecuteNonQuery();
                if (textBox1.Text == "" && textBox2.Text == "")
                {
                    MessageBox.Show("logged sucessfully!!", "Ready", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    _thread = new Thread(new ParameterizedThreadStart(FormStart));
                    _thread.Start();
                    Close();
                }
                else
                {
                    MessageBox.Show("Usuario ou Senha Esta incorreta!!", "Ready", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception E)
            {
                MessageBox.Show(E.ToString(), "Error , Voce nao consiguiu Logar!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
    }
}

[felipeboladao]

lol Nice idea

[Weezz]

Yeah the ideia is great but its not working right as i want =/

i hope some one come to help

[YukiXian]

What you mean with that "Definition" and "a form connected to db for VIP member login and get the server upgrades" ??

[Weezz]

look the pic atached...

i just want that to get the DataBase informations and check if id and pass are corect...

the rest ive fixed

[_Emme_]

Make it the easier way;

Console.Write("Database Username : ");
string User = Console.ReadLine();
Console.Write("Database Password : ");
string Pass = Console.ReadLine();

if (User == Database.UserName && Pass == Database.Password)
{
BLABLA
}
else
{
Console.WriteLine("Wrong information!!");
}

[Weezz]

Originally Posted by EmmeTheCoder

Make it the easier way;

Console.Write("Database Username : ");
string User = Console.ReadLine();
Console.Write("Database Password : ");
string Pass = Console.ReadLine();

if (User == Database.UserName && Pass == Database.Password)
{
BLABLA
}
else
{
Console.WriteLine("Wrong information!!");
}

YAY!! DID WORK !! THKS EMME

note: i might think about it before

[felipeboladao]

Help me is my code...
;D
Variables:

string User = " + TextBox1.text + ";
string Pass = " + TextBox1.text + ";

private void button1_Click_1(object sender, EventArgs e)
{
try
{
if (User == "" && Pass == "")
{
MessageBox.Show("Logado com Sucesso!!", "Ready", MessageBoxButtons.OK, MessageBoxIcon.Information);
_thread = new Thread(new ParameterizedThreadStart(FormStart));
_thread.Start();
Close();
}
else
{
MessageBox.Show("Usuario ou Senha Esta incorreta!!", "Ready", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception E)
{
MessageBox.Show(E.ToString(), "Error , Voce nao consiguiu Logar!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
}

[kinshi88]

private void button1_Click_1(object sender, EventArgs e)
{
User = " + TextBox1.text + ";
Pass = " + TextBox1.text + ";
try
{
if (User == "" && Pass == "")
{
MessageBox.Show("Logado com Sucesso!!", "Ready", MessageBoxButtons.OK, MessageBoxIcon.Information);
_thread = new Thread(new ParameterizedThreadStart(FormStart));
_thread.Start();
Close();
}
else
{
MessageBox.Show("Usuario ou Senha Esta incorreta!!", "Ready", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception E)
{
MessageBox.Show(E.ToString(), "Error , Voce nao consiguiu Logar!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
}


That should fix it.

[felipeboladao]

Error 5 The name 'User' does not exist in the current context C:\Documents and Settings\Diego - Servidor\Desktop\Conquer Online\Sparks CO Project\Form1.cs 55 21 COServerProject

Help me ,plx ;D

[YukiXian]

Originally Posted by felipeboladao

Error 5 The name 'User' does not exist in the current context C:\Documents and Settings\Diego - Servidor\Desktop\Conquer Online\Sparks CO Project\Form1.cs 55 21 COServerProject

Help me ,plx ;D

Don't be stupid, Make a string of it,,,

[felipeboladao]

help me to conect at The Database ...

private void button1_Click_1(object sender, EventArgs e)
        {
            User = " + TextBox1.text + ";
            Pass = " + TextBox1.text + ";
            try
            {
                User = "";
                Pass = "";
                    MySqlCommand Command = null;
                    Command = new MySqlCommand("SELECT * FROM `Users` WHERE `User` = '" + Pass + "' WHERE `Pass` = '" + Pass + "'", DataBase.Connection);
                    Command.ExecuteNonQuery();
                if (User == " + User + " && Pass == " + Pass + ")
                {
                    MessageBox.Show("Logado com Sucesso!!", "Ready", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    _thread = new Thread(new ParameterizedThreadStart(FormStart));
                    _thread.Start();
                    Close();
                }
                else
                {
                    MessageBox.Show("Usuario ou Senha Esta incorreta!!", "Ready", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception E)
            {
                MessageBox.Show(E.ToString(), "Error , Voce nao consiguiu Logar!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
    }
}