MySQL reader usage C#

Question

Ive been having some problems with understanding the MySql reader from MySql.Data.MySqlClient

This is my Code:

while (reader.Read())
{
    documentButtons = new RadioButton[3];
    for (int i = 0; i < 3; i++)
    {
        documentButtons[i] = new RadioButton();
        documentButtons[i].Text = reader["name"].ToString() + " " + (i + 1);

        Console.WriteLine(reader["name"].ToString());

        documentButtons[i].Location = new System.Drawing.Point(10, 10 + i * 20);
        this.Controls.Add(documentButtons[i]);
    }
}
Console.ReadLine();

This makes 3 radiobuttons with the texts: "Dokument1 1", "Dokument1 2", "Document1 3" As you can probably see, i want the number right behind "Dokument" to be equal to the number behind that. (My 3 first entries in the database is "Dokument1", "Dokument2" and "Dokument3". In my console, "Dokument1", 2 and 3, all show up 3 times. How can i make it create the appropriate name on the appropriate radiobutton?

Why is the for loop there at all, if what you want is just the three radio buttons? You're building three for each database record, it looks like. — reallyJim
– reallyJim, Commented Nov 16, 2011 at 19:15

knittl · Accepted Answer · 2011-11-16 19:15:54Z

4

I'm not sure I fully understand your question, but if you simply want to have a single RadioButton for each row returned, the following code should work:

documentButtons = new RadioButton[3];
int i = 0;
while (i <= 3 && reader.Read()) { // make sure we don't get an IndexOutOfRangeException
  documentButtons[i] = new RadioButton();
  documentButtons[i].Text = reader["name"].ToString() + " " + (i + 1);

  Console.WriteLine(reader["name"].ToString());

  documentButtons[i].Location = new System.Drawing.Point(10, 10 + i * 20);
  this.Controls.Add(documentButtons[i]);

  ++i;
}

answered Nov 16, 2011 at 19:15

knittl

269k59 gold badges339 silver badges405 bronze badges

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

3 Comments

reallyJim Over a year ago

I like that you just posted nearly letter for letter the answer I was typing. :)

knittl Over a year ago

@reallyJim: you have to type FASTER! ;)

Raptor Over a year ago

Ah, it was the while with the reader and the "i" i was looking for, thanks a lot :) Works like a charm thank you :D

Collectives™ on Stack Overflow

MySQL reader usage C#

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related