Databind UI SQL LinQ

Mar 8, 2009 at 1:32 AM
Hello,

I am very new to all this programming. I'm using C# in visual studio and the ASP.NET - and im doing code behind.
I have collected som data from my database in a class, but I dont know how to show it in the Google Map control. The addresses is just throwing a city back without any zip code or anything.

(My method)

        var query = from p in db.Farms
                    where p.FarmID == 2
                    select new
                    {
                        p.FarmAddress
                    };

My google control
    <artem:GoogleMap ID="GoogleMap1" runat="server" width="620px" height="300px"  Key="ABQIAAAAg9acVny3-tiP5QtfzcpiWRRnlnGJE4rl1xBVHfIloNbo-MToRxTTP0CPusiEpTy-UyUPG2NHC6p-fw" Zoom="5" Latitude="56" Longitude="9"  >
        <Markers>
            <artem:GoogleMarker Address="athens greece" Text="Athens" />
            <artem:GoogleMarker Address="<%#EVAL("query")" Text="Athens" />
         </Markers>
    </artem:GoogleMap>

Hope that anyone can help...

Best regards
Klaus