Asp.net C# Display multiple row value of a single column in a single level

Question

I am trying to display all the TrailerNo from ICDTmpTrailerMovemnt table in lblTrailerNo label using following code.But it is showing the first row value multiple times But how can i fetch all the rows of that particular column like

CMDHA-610023 CMDHA-610024 CMDHA-610026 CMDHA-610027 CMDHA-610028 CMDHA-610029 CMDHA-610030 CMDHA-610031 etc

    String con = dbcon;
    String SQL = "select TrailerNo from ICDTmpTrailerMovemnt";
    SqlDataAdapter Adpt = new SqlDataAdapter(SQL, con);
    DataSet ds = new DataSet();
    Adpt.Fill(ds);

    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        lblTrailerNo.Text += ds.Tables[0].Rows[0]["TrailerNo"].ToString() + "<br />";

    }

Cristian Szpisjak · Accepted Answer · 2017-05-18 03:35:10Z

3

foreach (DataRow dr in ds.Tables[0].Rows)
{
    lblTrailerNo.Text += dr["TrailerNo"].ToString() + "<br />";

}

answered May 18, 2017 at 3:35

Cristian Szpisjak

2,4792 gold badges22 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Asp.net C# Display multiple row value of a single column in a single level

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related