A field or property with the name 'Id' was not found on the selected data source.

I'm working on a gridview, trying to get it to show the value of a table translated into text from another table, if you get what i mean, but it gives me the above error

A field or property with the name 'Id' was not found on the selected data source.

I cant figure out why it tells me that, table does have a column called Id

Heres the code

   <asp:TemplateField HeaderText="Reason For Access">
                                <ItemTemplate>
                                    <asp:Label ID="locationLabel" runat="server" Text='<%# Reason( (int) Eval("reason_Id") ) %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>

and the code behind

 SqlConnection myConnectionSetting = new SqlConnection(ConfigurationSettings.AppSettings["VisitorAccessConnectionString"]);
            myConnectionSetting.Open();
            SqlDataReader myReader = null;
            SqlCommand myCommand = new SqlCommand("SELECT * FROM [ReasonForAccess] WHERE (Id = '" + reason_Id + "')", myConnectionSetting);
            myReader = myCommand.ExecuteReader();
            while (myReader.Read())
            {
                location = myReader["Reason"].ToString();
            }

The table, contains the columns, Id and Reason


Thanks