How to retrieve data from database mySQL using MySqlDataReader?

Question

I want to retrieve some specific data from tblBranches based to the choice of the user in the combobox (cboBranch.Text), one is the class_name but when I tried to run the program the messagebox shows MySql.Data.MySqlClient.MySqlDataReader, so how can I properly retrieve the data in my database?

query = "SELECT class_name FROM tblBranches WHERE branch_name=@branch";

MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.Add("@branch", MySqlDbType.VarChar, 30).Value = _order.cboBranch.Text;

MySqlDataReader dr;

con.Open();
dr = cmd.ExecuteReader();

string class_name = dr.ToString();

MessageBox.Show(class_name);

con.Close();

davmos · Accepted Answer · 2013-05-12 06:34:19Z

1

Rather than call the ToString() method, you need to to call the GetString() method passing the zero-based index of the ordinal position of the column in your query, zero in this case because there is only one column in your query.

Before that, you must call the Read() method to advance the reader onto the first or next record and you also need to check the return value because it will return a bool to indicate if another record was found.

So replace this line...

string class_name = dr.ToString();

With

string class_name = dr.Read() ? dr.GetString(0) : "Nothing Found";

Or if there could be more than one record returned...

string class_names = string.Empty;

while (dr.Read())
    class_names = dr.GetString(0) + "\n";

edited May 12, 2013 at 6:34

answered May 12, 2013 at 6:09

davmos

9,6074 gold badges45 silver badges46 bronze badges

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

2 Comments

Harvey Over a year ago

I didn't understand? What do you mean?

davmos Over a year ago

I've expanded the answer. If you still don't understand, tell me which part you don't understand exactly.

JKMurray · Accepted Answer · 2013-05-13 12:13:34Z

0

Just an addition: isn't is easier to use ExecuteScalar in case there's only 1 row to expect as a result?

Example:

MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.Add("@branch", MySqlDbType.VarChar, 30).Value = _order.cboBranch.Text;

var class_name = cmd.ExecuteScalar();

if (class_name != null)
{
    //DoSomething with your result here.
}else{
    //Item not found, handle it here
}

answered May 13, 2013 at 12:13

JKMurray

373 bronze badges

Collectives™ on Stack Overflow

How to retrieve data from database mySQL using MySqlDataReader?

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related