[b]lezen.aspx[/b]
<%@ Page Language="C#" AutoEventWireup="true" Debug="true" CodeFile="lezen.aspx.cs" Inherits="lezen" %>
Gastenboek | Lezen
[b]lezen.aspx.cs[/b]
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class lezen : System.Web.UI.Page
{
OleDbConnection verbinding = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=LOCATIE\\gastenboek.mdb");
OleDbCommand ophalen;
OleDbDataReader lezen;
string tijd, naam, bericht, ophalen_query, resultaat;
protected void Page_Load(object sender, EventArgs e)
{
tijd = "";
naam = "";
bericht = "";
resultaat = "";
ophalen_query = "SELECT * FROM berichten";
ophalen = new OleDbCommand(ophalen_query, verbinding);
try
{
verbinding.Open();
lezen = ophalen.ExecuteReader();
while (lezen.Read())
{
resultaat += "Door: ";
resultaat += lezen.GetString(2);
resultaat += " Datum: ";
resultaat += lezen.GetString(1);
resultaat += " |
";
resultaat += lezen.GetString(3).Replace("\n", " ");
resultaat += " |
";
berichten_label.Text += resultaat;
}
lezen.Close();
catch (Exception x)
{
Response.Write(x.Message);
}
finally
{
verbinding.Close();
}
berichten_label.Text = resultaat;
}
}
[b]schrijven.aspx[/b]
<%@ Page Language="C#" AutoEventWireup="true" Debug="true" CodeFile="schrijven.aspx.cs" Inherits="_Default" %>
Gastenboek | Schrijven
[b]schrijven.aspx.cs[/b]
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
OleDbConnection verbinding = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=LOCATIE\\gastenboek.mdb");
OleDbCommand invoegen;
string tijd, naam, bericht, invoeren_query;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void verzenden_Click(object sender, EventArgs e)
{
tijd = DateTime.Now.ToString();
naam = Server.HtmlEncode(naam_vak.Text);
bericht = Server.HtmlEncode(bericht_vak.Text);
if (naam == "" || bericht == "")
{
fouten.Text = "Alles invullen";
}
else
{
if (naam.Contains("/") || naam.Contains("\\") || naam.Contains("<") || naam.Contains(">"))
{
fouten.Text = "Geen speciale tekens in de naam";
}
else
{
if (bericht.Contains("/") || bericht.Contains("\\") || bericht.Contains("<") || bericht.Contains(">"))
{
fouten.Text = "Geen speciale tekens in het bericht";
}
else
{
invoegen_query = "INSERT INTO berichten(tijd, naam, bericht) VALUES('" + tijd + "', '" + naam + "', '" + bericht + "') ";
invoegen = new OleDbCommand(invoegen_query, verbinding);
try
{
verbinding.Open();
invoegen.ExecuteNonQuery();
verbinding.Close();
Response.Redirect("lezen.aspx");
}
catch (Exception x)
{
fouten.Text = x.Message;
}
}
}
}
}
}