C# - Error With Getting Data From mySQL Database

Question

I am currently getting an error when trying to get data from mySQL:

Additional information: Could not find specified column in results: admin

My code is:

public int getLevel()
    {
        string sqlCommand = "Select level from users where username = 'admin'";
        int value = 0;

        MySqlConnection con = new MySqlConnection("host=111.222.111.222;user=MYUSERNAME;password=MYPASSWORD;database=tcg;");
        MySqlCommand cmd = new MySqlCommand(sqlCommand, con);

        con.Open();

        MySqlDataReader reader = cmd.ExecuteReader();

        while (reader.Read())
        {
            value += int.Parse(reader.GetString("admin"));
        }
        return value;
    }

Before you start coding too much, utilize using blocks for safe resource use. Otherwise all your code will look like the above :p — Drew
– Drew, Commented Sep 21, 2016 at 21:03
If you have never worked with resultsets before then just say so and someone can maybe type up an answer. But it is like Hour 1 of a tutorial and stackoverflow is not that kind of a site — Drew
– Drew, Commented Sep 21, 2016 at 21:11

Shannon Holsinger · Accepted Answer · 2016-09-21 21:25:25Z

1

Try:

 public int getLevel()
 {
     int value = 0;
     using(MySqlConnection con = new MySqlConnection("host=45.37.80.181;user=MYUSERNAME;password=MYPASSWORD;database=tcg;"))
     {
         con.Open();
         using(MySqlCommand cmd = con.CreateCommand())
         {
             cmd.CommandText = "Select level from users where username = @ad";
             cmd.Parameters.AddWithValue("@ad","admin");
             MySqlDataReader reader = cmd.ExecuteReader();

             while (reader.Read())
             {
                 value += int.Parse(reader[0]);
             }
        }
        con.Close();
     }
     return value;
}

If you only have one admin, use:

public int getLevel()
 {
     int value = 0;
     using(MySqlConnection con = new MySqlConnection("host=45.37.80.181;user=MYUSERNAME;password=MYPASSWORD;database=tcg;"))
     {
         con.Open();
         using(MySqlCommand cmd = con.CreateCommand())
         {
             cmd.CommandText = "Select level from users where username = @ad";//add Order by if you need to
             cmd.Parameters.AddWithValue("@ad","admin");
             value += Convert.ToInt32(com.ExecuteScalar());//this assumes you will get an integer value

        }
        con.Close();
     }
     return value;
}

edited Sep 21, 2016 at 21:25

answered Sep 21, 2016 at 21:10

Shannon Holsinger

2,3811 gold badge17 silver badges22 bronze badges

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

2 Comments

Drew Over a year ago

Not sure why you got a DV. Here is one up. Thx for helping the op

Shannon Holsinger Over a year ago

'cause I put TOP in the SELECT statement which is SQL not MySQL. Someone got their panties in a bunch before I could edit it. No worries - glad it helped. Cheers!

Collectives™ on Stack Overflow

C# - Error With Getting Data From mySQL Database

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