A bit of help C# and MySql

[.Beatz]

Hey guys, dont know if this is the right place but I will post here anyway...

I am writing a program and I am having some issues with selecting the MySql data using C#.

private void Checks()
        {
            string UN = Username_Text.Text;
            string Pass = Password_Text.Text;

            MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);

            try
            {

                cmd.Select("users").Where("Username", UN);
                MySqlReader r = new MySqlReader(cmd);

                while (r.Read()) // Breakpoint added here shows that the program is reading up to this point but does not read anything below this line until the return;
                {
                    string RealPassword = r.ReadString("Password");
                    string RealUsername = r.ReadString("Username");
                    if (RealUsername == UN && RealPassword == Pass)
                    {
                        MessageBox.Show("YAY!");
                    }
                    else
                    {
                        MessageBox.Show("DAMN!");
                    }
                }
                return;
            }
            catch (Exception Exc) { MessageBox.Show(Exc.ToString()); }
        }

Anyone can help me with this? Its a simple login script but I just cant get my head around it and need a fresh pair of eyes

Thanks in advance

.Beatz

My MySql DLL is attached

[wraith808]

Where is your MySQL Dll from?  Is it yours, or did you get it from somewhere?  If you got it from somewhere, I'd suggest placing a link to where.  If it's yours, I'd suggest posting source instead. 

Why?

Well, not to be a cynic, but you have one post.  I'm not going to download anything I'm not totally sure of from someone with one post.  Sorry, but that's a sign of the internet times.

[.Beatz]

downloaded from Elitepvpers.de... It come in a source that I was working on and can't find the source code for it or the download link...

I  know I only have one post but I can assure you that the DLL is what I say it is... a dll nothing else nothing more.

I will keep looking for the download I got it from and will post it if I can find it...

[KynloStephen66515]

I will back Beatz up on this as I do know him.

I _tried_ to help on this subject but I kinda failed lol

*edit*

Downloaded the rar file and uploaded it to my post, its legit (Couldnt upload as a direct .dll so had to re-rar it lol)

If you wanna download it DIRECTLY as ONLY a .dll, then use this link:

http://86.28.143.246/MySqlHandler.dll (MY Web Server)

[Stoic Joker]

What errors are you getting, and what is the structure of the table you're querying?

[.Beatz]

I am not getting any errors it just wont read anything from the database... so far I have Username and Password fields in the MySql database I have tried using a connection string instead of this dll but failed miserably while trying to select Username as row and get the password from the same row...

Sorry for the erratic way I have written stuff I am not very good at explaining things lol (just ask Stephen)

[Stoic Joker]

Is the database you connecting to defined elsewhere?

Why is there no FROM {TABLE} reference in the code?

Granted I know nothing of this dll you're trying to use but this line just don't look right:

Code: (csharp)

cmd.Select("users").Where("Username", UN);

Shouldn't it be something more like:

Code: (csharp)

cmd.Select("Username, Password").From.("Users").Where("Username", UN);

Considering (I'm left guessing...) you're probably getting the DAMN! messagebox ... It's probably returning an empty results set, or a query syntax error that isn't being seen/checked for.

[wraith808]

I'd agree with SJ on this one.  It appears like a syntax problem with the DLL you are using rather than a C# problem.  I tried to find a reference online to that DLL and maybe documentation and found something, but I can't download without registering.

It seems that there is source on that site that uses it in this thread.  I can't download it to see since I'm not registered, but I'd recommend downloading it and taking a look to see what the syntax should be from the source.

Also, if you're just trying to use MySQL and can't get this to work, you might look into MySQL Connector/NET.  There's a good tutorial on using it here.

[Stoic Joker]

Also, if you're just trying to use MySQL and can't get this to work, you might look into MySQL Connector/NET.  There's a good tutorial on using it here.

I'll second that, I've used the MySQL supplied SKD for a couple of C++ projects. All of which worked out quite well.

[.Beatz]

@Stoic Joker - I am defining the database when the program loads. Also I am not getting either MessageBox

I will try and use the MySql connector/NET and see if that helps at all

Will keep you up to date on how its going and if I need a hand

Cheers guys helped quite alot

*EDIT*

Found out the dll keeps a constant connection so the message boxes wouldn't show up.

Spoiler (click to show/hide)

public bool Checks()
        {
            MySqlConnection Conn = MySqlSettings.GetConnection(); Conn.Open();
            bool exist = false;
            string user = Username_Text.Text;
            string userpass = Password_Text.Text;

            try
            {
                lock (Conn)
                {
                    MySqlCommand Cmd = new MySqlCommand("SELECT * FROM `users` WHERE Username='" + user + "' AND Password='" + userpass + "'", Conn);
                    MySqlDataReader DR = Cmd.ExecuteReader();
                    while (DR.Read())
                    {
                        string userpass1;
                        string user1;

                        userpass1 = (DR["Password"].ToString());
                        user1 = (DR["Username"].ToString());

                        if (user == user1 && userpass == userpass1)
                        {
                            exist = true;
                        }
                    }
                    DR.Close();
                }
                Conn.Close();
            }
            catch (Exception)
            {
                Conn.Close();
                return true;
            }
            if (exist == true)
            {
                MessageBox.Show("Logged in");
            }
            else
            {
                MessageBox.Show("Username or Password is wrong\nPlease try again");
            }

            return exist;
        }

Now it works like a dream as long as I don't use the dll

Cheers for the help guys

[Ath]

if (exist == true)

Why do you code double comparisons? 'exist' is a boolean already, so it's either true or false, writing 'if (exist)' is sufficient.

[.Beatz]

I do that when I am working on some things to help me look around and see stuff easier