diplay data from Mysql table line after line in a label

Inaam Hammouda

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(this,"No 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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
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 Hammouda10y ago
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 Susaimichael10y ago
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(this,"No data found.", "No Data");
}
else
{
foreach (DataRow dr in dt.Rows)
{

vitesseVal.Text =vitesseVal.Text + dr[0] + "";

}
}
}