Query = "select * from register ";
SqlCommand cmd = new SqlCommand(Query, con);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
lblid.Text = dr["mcode"].ToString() + " - " + dr["fullname"].ToString();
}}
i hve the above code
only the first record gets displayed . all the records needs to be displayed