[SQL ] sqlserver請問這樣的寫法哪裡有錯

[GN00505257 (...)]

讀取出來的應該是多筆資料
請問為什麼都只出現一筆資料再label裡面?
但是如果丟在response.write裡面又可以出現多筆

    protected void Button11_Click(object sender, EventArgs e)
    {
        var cn = new SqlConnection();
        cn.ConnectionString = @"Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\GoogleMapDatabase.mdf;Integrated
Security=True;User Instance=True";
        var cmd = new SqlCommand();
        cmd.Connection = cn;
        cmd.CommandText = "SELECT LatLng FROM Markers WHERE Routename =
@RouteName";
        cmd.Parameters.AddWithValue("@RouteName",
RouteSelection.SelectedItem.Text);
        cn.Open();
        var records = cmd.ExecuteReader();

        if (records.HasRows)
        {
          while (records.Read())
            {
                Label13.Text = records["LatLng"].ToString();
            }
        }
        else
        {
            Response.Write("not found");
        }

        cn.Close();
    }



感謝各位了

--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.25.118.133
※ 編輯: GN00505257      來自: 163.25.118.133       (11/03 02:39)