Hab das mal gemacht:
<%@ Page Language="C#" AutoEventWireup="true" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Frei-/Belegtinformationen</title>
<script runat="server" type="text/C#">
private string GetString(bool value)
{
if (value)
return "belegt";
else
return "frei";
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
SqlDataSource ds = (SqlDataSource)e.Item.FindControl("SqlDataSource1");
ds.SelectParameters["Datum"].DefaultValue = ((System.Data.DataRowView)e.Item.DataItem)["Datum"].ToString();
}
</script>
<style type="text/css">
div.False {
background-color: red;
color: white;
}
div.True {
background-color: green;
color: white;
}
span[title~=False] {
background-color: red;
}
span[title~=True] {
background-color: green;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TestenConnectionString %>"
SelectCommand="SELECT DISTINCT [Datum] FROM [Reservation]"></asp:SqlDataSource>
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource2" OnItemDataBound="DataList1_ItemDataBound">
<ItemTemplate>
<asp:Label ID="DatumLabel" runat="server" Text='<%# Eval("Datum") %>' Font-Bold="true" />
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestenConnectionString %>"
SelectCommand="SELECT * FROM [Reservation] where Datum = @Datum">
<SelectParameters>
<asp:Parameter Name="Datum" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="Zeit" HeaderText="Zeit" SortExpression="Zeit" />
<asp:TemplateField HeaderText="Raum 1">
<ItemTemplate>
<div class='<%# Eval("Raum 1") %>'>
<%# GetString((bool)Eval("Raum 1")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 2">
<ItemTemplate>
<div class='<%# Eval("Raum 2") %>'>
<%# GetString((bool)Eval("Raum 2")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 3">
<ItemTemplate>
<div class='<%# Eval("Raum 3") %>'>
<%# GetString((bool)Eval("Raum 3")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 4">
<ItemTemplate>
<div class='<%# Eval("Raum 4") %>'>
<%# GetString((bool)Eval("Raum 4")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 5">
<ItemTemplate>
<div class='<%# Eval("Raum 5") %>'>
<%# GetString((bool)Eval("Raum 5")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 6">
<ItemTemplate>
<div class='<%# Eval("Raum 6") %>'>
<%# GetString((bool)Eval("Raum 6")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 7">
<ItemTemplate>
<div class='<%# Eval("Raum 7") %>'>
<%# GetString((bool)Eval("Raum 7")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 8">
<ItemTemplate>
<div class='<%# Eval("Raum 8") %>'>
<%# GetString((bool)Eval("Raum 8")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 9">
<ItemTemplate>
<div class='<%# Eval("Raum 9") %>'>
<%# GetString((bool)Eval("Raum 9")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Raum 10">
<ItemTemplate>
<div class='<%# Eval("Raum 10") %>'>
<%# GetString((bool)Eval("Raum 10")) %>
</div>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<br />
</ItemTemplate>
</asp:DataList>
</div>
</form>
</body>
</html>
Ergebnis hier:
http://blogimages.hauserinfo.de/FreiGebucht.PNG
Thomas Hauser (Trainer und Consultant, Blog: http://thomashauser.spaces.live.com, Forum: http://www.sharepointbook.de - Die Forum-Webseite zum Buch!)
