<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="true" %>
<%@ import namespace="System.IO"%>
<%@ import namespace="System.Data"%>
<%@ import namespace="System.Data.OleDb"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd"><script runat="server">
void Page_Load(Object Sender, EventArgs E) {
if (!IsPostBack) {
OleDbConnection OurConnection;
OleDbCommand OurCommand;
OleDbDataAdapter OurDataAdapter;
DataSet OurDataSet = new DataSet();
OurConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("../database/ns.mdb")+";");
OurConnection.Open();
OurCommand = new OleDbCommand("SELECT ID, navn, tlfnummer, mobil, adresse, mail, omraade, sommerhusadresse, aktiv FROM huse", OurConnection);
OurDataAdapter = new OleDbDataAdapter(OurCommand);
OurDataAdapter.Fill(OurDataSet, "huse");
TheRepeater.DataSource=OurDataSet.Tables["huse"];
DataBind();
}
}
public bool FormatCheckBox(string aktiv)
{
if(aktiv=="ja")
{
return true;
}
return false;
}
protected void InsertCommand(object sender, RepeaterCommandEventArgs e){
CheckBox CbAktiv= e.Item.FindControl("CbAktiv") as CheckBox;
string strAktiv;
if (CbAktiv.Checked)
{
strAktiv="ja";
}
else
{
strAktiv = "slettet";
}
OleDbConnection OurConnection;
OurConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("../database/ns.mdb")+";");
OleDbCommand OurCommand;
OurCommand = new OleDbCommand("INSERT INTO huse (aktiv) Values (@aktiv)" ,OurConnection);
OurCommand.Parameters.Add("@Aktiv", OleDbType.VarChar, 10).Value = strAktiv;
OurConnection.Open();
OurCommand.ExecuteNonQuery();
OurConnection.Close();
}
</script>
<html>
<head>
<title>aktiver</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style/ns.css" rel="stylesheet" type="text/css">
</head>
<body>
<form runat="server">
<ASP:Repeater id="TheRepeater" OnItemCommand="InsertCommand" runat="server"><ItemTemplate>
<table border="0" cellspacing="0" cellpadding="0" background="../images/bg.gif" align="center">
<tr>
<td>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#E5F0FF">
<tr>
<td width="40" align="center"><%# DataBinder.Eval(Container.DataItem, "ID") %></td>
<td width="180"><%# DataBinder.Eval(Container.DataItem, "navn") %></td>
<td width="100"><%# DataBinder.Eval(Container.DataItem, "tlfnummer") %></td>
<td width="100"><%# DataBinder.Eval(Container.DataItem, "mobil") %></td>
<td width="180"><%# DataBinder.Eval(Container.DataItem, "omraade") %></td>
<td width="280"><%# DataBinder.Eval(Container.DataItem, "sommerhusadresse") %></td>
<td width="40"><asp:CheckBox ID="CbAktiv" Text="ja" runat="server" Checked='<%# (bool)DataBinder.Eval(Container.DataItem, "aktiv") %> ' /></td>
<td><asp:Button ID="btUpdate" Text="Opdater" runat="server" /></td>
</tr>
</table>
<br>
</td>
</tr>
</table>
<br>
<div align="center"></div>
</ItemTemplate></ASP:Repeater>
</form>
</body>
</html>
