Retrieve specific value from MySQL DB in C#

Question

I am working with a MySQL sign up/registration system. If the user and pass are correct and has permission 0, he will log in as guest; if the user and pass are correct and user has permission 1, he will log in as administrator. If the user is guest, I want to open Form1, if he is admin, I will open Form 2. At this point my program reads / writes to the MySQL DB. How can I read a specific value (permission) and write conditionals depending on the result?

Auth :

        private bool validate_login(string user, string pass)
    {
        db_connection();
        MySqlCommand cmd = new MySqlCommand();
        cmd.CommandText = "Select * from miembros where usuario=@user and contraseña=@pass";
        cmd.Parameters.AddWithValue("@user", textBox1.Text);
        cmd.Parameters.AddWithValue("@pass", textBox2.Text);
        cmd.Connection = connect;
        MySqlDataReader login = cmd.ExecuteReader();
        if (login.Read())
        {

            connect.Close();
            return true;
        }
        else
        {
            connect.Close();
            return false;
        }
    }

Hazem Torab · Accepted Answer · 2016-03-19 21:32:12Z

1

Just access the data reader

if (login.Read())
        {
            x = login["FieldName"];
            connect.Close();
            return true;
        }
        else
        {
            connect.Close();
            return false;
        }

a general advice to you when you are going to use MySQL with C#, it's better to use a framework like NHibernate that will help you with data access and date formats and many other things.

answered Mar 19, 2016 at 21:32

Hazem Torab

3791 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alberto Lopez Rodriguez Over a year ago

Where x is a string, int or bool?

Hazem Torab Over a year ago

x is an object and you can cast the result or you can use login.GetInt32(0); if you are want to retrieve integervalue

Collectives™ on Stack Overflow

Retrieve specific value from MySQL DB in C#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related