gegevens ophalen uit sql

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Locaties.aspx.cs" Inherits="Locaties" Title="Untitled Page" culture="auto" uiculture="auto" meta:resourcekey="PageResource1" %>

<asp:Content ID="cContentTitle" ContentPlaceHolderID="cphContentTitle" Runat="Server">
  <asp:Label ID="lblTitle" runat="server" meta:resourcekey="lblTitleResource1">Locaties</asp:Label>
</asp:Content>

<asp:Content ID="cContent" ContentPlaceHolderID="cphContent" Runat="Server">
  <br />
  <asp:Repeater ID="repCategorie" runat="server" DataSourceID="ldsCategorie">
    <ItemTemplate>
      <asp:HiddenField ID="hfCategorieId" runat="server" Value='<%# Eval("Id") %>' />
		        <h1><asp:Label ID="lblCategorieItem" runat="server" Text='<%# Eval("Titel") %>' meta:resourcekey="lblCategorieItemResource1" CssClass="font_title" /></h1>
		        <div id="location_block">
	          <asp:Repeater ID="repLocatieItem" runat="server" DataSourceID="ldsLocatie" OnItemDataBound="repLocatieItem_OnItemDataBound">
            <ItemTemplate>
              <table cellspacing="5">
                <tr>
                  <td style="width:150px;vertical-align:top;">
                    <asp:Image ID="imgLocatie" runat="server" ImageUrl='<%# ((Eval("Fotopath") == null) ? "~/media/locatie/default.jpg" : (Eval("Fotopath").ToString().Contains("http://") ? Eval("Fotopath") : "~/media/locatie/" +  Eval("Fotopath"))) %>' meta:resourcekey="imgLocatieResource1" />
                  </td>
                  <td style="vertical-align:top;">
                    <asp:HyperLink ID="hpTitle" runat="server" Text='<%# Eval("Titel") %>' NavigateUrl='<%# "~/Locaties/" + Various.ReplaceNonHTMLCharsForUrl(Eval("Titel").ToString()).Replace(" ", "-") + ".aspx" %>' meta:resourcekey="hpTitleResource1" CssClass="l_locname" /><br />
                    <asp:Label ID="lblTekstNL" runat="server" Text='<%# Eval("Text_nl") %>' Visible="false"></asp:Label>
                    <asp:Label ID="lblTekstFR" runat="server" Text='<%# Eval("Text_fr") %>' Visible="false"></asp:Label>
                  </td>
                </tr>
              </table> 
            </ItemTemplate>
          </asp:Repeater>
          <asp:LinqDataSource ID="ldsLocatie" runat="server" ContextTypeName="BKFreerollDataContext" TableName="Locaties" Where="LocatieCategorieId == @LocatieCategorieId AND Actief == True AND IsDeleted == False" OrderBy="Volgorde">
            <WhereParameters>
              <asp:ControlParameter ControlID="hfCategorieId" Name="LocatieCategorieId" PropertyName="Value" Type="Int32" DefaultValue="1" />
            </WhereParameters>
          </asp:LinqDataSource>
      </div>
    </ItemTemplate>
  </asp:Repeater>
  <asp:LinqDataSource ID="ldsCategorie" runat="server" 
    ContextTypeName="BKFreerollDataContext" TableName="LocatieCategories" 
    onselecting="ldsCategorie_Selecting">
  </asp:LinqDataSource>
  &nbsp;
</asp:Content>