How to loop through a database table and create a button for column

Question

I am trying to loop through a DB and create a button for each row based on my query. I should be getting 3 buttons in return however only one is being created.

 DataTable dt = new DataTable();
 con.Open();
 string TeamID = (string)Session["TeamID"];
 SqlDataReader myReader = null;
 SqlCommand myCommand = new SqlCommand("SELECT * FROM Players1 WHERE 
 TeamID = " + teamID, con);
 myCommand.Parameters.AddWithValue("@TeamID", TeamID);
 myReader = myCommand.ExecuteReader();
 while (myReader.Read())
 {
   foreach (Object ob in myReader)
 {
  Button1.Text = "" + (myReader["Name"].ToString());
  }
 }

I should be getting 3 buttons based on the data in my DB

Bosco · Accepted Answer · 2019-08-18 09:26:22Z

3

You need to create or instantiate the Button object itself, and then assign value to it.

about getting data from your myReader object see this

DataTable dt = new DataTable();
con.Open();
string TeamID = (string)Session["TeamID"];
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("SELECT * FROM Players1 WHERE 
TeamID = " + teamID, con);
myCommand.Parameters.AddWithValue("@TeamID", TeamID);
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
    foreach (Object ob in myReader)
    {
        Button btn = new Button();
        btn.ID = "Btn_" + ob["Id"]; //I assume the table has an Id
        btn.Text = ob["Name"]; //I also assume the table has a Name column
        //for click events
        //btn.Click = btn_Click_Event; 
    }
}

edited Aug 18, 2019 at 9:26

answered Jun 22, 2019 at 19:29

Bosco

1,5522 gold badges14 silver badges25 bronze badges

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

Comments

Mr.Malte · Accepted Answer · 2019-06-22 16:01:34Z

-2

I dunno exactly where you should be getting three buttons. From what it looks like, you're just changing the text of Button1, which is a single button. You're changing the text of Button1 three times. You want Button2 and Button3 to change as well, I guess.

answered Jun 22, 2019 at 16:01

Mr.Malte

271 bronze badge

2 Comments

Liam12 Over a year ago

Yes, but how do I dynamically create a button for each row in the DB

Sergey Krusch Over a year ago

You really should either try to answer the question, or just not post an answer at all.

Collectives™ on Stack Overflow

How to loop through a database table and create a button for column

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related