diplay data from Mysql table line after line in a label

Question

hi  i want to read and display data from Mysql table into a label in my winform app. i tried this : string sql = SELECT vitesse FROM val_api;; MySqlDataAdapter da = new MySqlDataAdapter(sql conn); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count == 0) { MessageBox.Show(thisNo data found. No Data); } else { foreach (DataRow dr in dt.Rows) { vitesseVal.Text = dr[0] + ; break; } } } but it only shows the first row only any help please

Francis · Answer

Have you debugged the application by keeping the break point? so that you can easily knows the number of rows available in data table. Try to debug the application.

Inaam Hammouda · Answer

hi  thanks a lot for the replay when i deleted the break nothing showed off at all . with a break it just shows the first row

Francis · Answer

Based on your code it will read a row and break the loop. That is the reason. Your code should be like this: string sql = SELECT vitesse FROM val_api;; MySqlDataAdapter da = new MySqlDataAdapter(sql conn); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count == 0) { MessageBox.Show(thisNo data found. No Data); } else { foreach (DataRow dr in dt.Rows) { vitesseVal.Text = vitesseVal.Text + dr[0] + ; } } }