Skip to content

Instantly share code, notes, and snippets.

@s0ren

s0ren/kontakt.aspx

Created June 8, 2015 12:20
Show Gist options
  • Save s0ren/ae18b2c2654f3b12f802 to your computer and use it in GitHub Desktop.
Save s0ren/ae18b2c2654f3b12f802 to your computer and use it in GitHub Desktop.
Download ZIP
En kontakt side, med insert i databasen
Raw
kontakt.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="kontakt.aspx.cs" Inherits="kontakt" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table class="auto-style1">
<tr>
<td>Navn:</td>
<td>
<asp:TextBox
ID="TextBoxNavn" runat="server" CausesValidation="True"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidatorNavn"
Text="Mangler"
ControlToValidate="TextBoxNavn" runat="server" ErrorMessage="RequiredFieldValidator" EnableClientScript="False" ValidationGroup="kontakt"></asp:RequiredFieldValidator>
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Email:</td>
<td>
<asp:TextBox
ID="TextBoxEmail" runat="server" CausesValidation="True"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidatorEmail"
Text="Mangler"
ControlToValidate="TextBoxEmail" runat="server" ErrorMessage="RequiredFieldValidator" EnableClientScript="False" Display="Dynamic" ValidationGroup="kontakt"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator
ID="RegularExpressionValidatorEmail"
Text="Skal være en email" runat="server" ErrorMessage="RegularExpressionValidator" ControlToValidate="TextBoxEmail" EnableClientScript="False" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" ValidationGroup="kontakt"></asp:RegularExpressionValidator>
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Telefon:</td>
<td>
<asp:TextBox
ID="TextBoxTelefon" runat="server" CausesValidation="True"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidatorTelefon"
Text="Mangler"
ControlToValidate="TextBoxTelefon" runat="server" ErrorMessage="RequiredFieldValidator" EnableClientScript="False" ValidationGroup="kontakt"></asp:RequiredFieldValidator>
<%-- <asp:RegularExpressionValidator
ID="RegularExpressionValidatorTelefon"
ValidationExpression="" runat="server" ErrorMessage="RegularExpressionValidator" ControlToValidate="TextBoxTelefon" EnableClientScript="False">Skal være telefonnummer</asp:RegularExpressionValidator>--%>
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>Besked:</td>
<td>
<asp:TextBox
ID="TextBoxBesked"
TextMode="MultiLine" runat="server" CausesValidation="True"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidatorBesked"
Text="Mangler"
ControlToValidate="TextBoxBesked" runat="server" ErrorMessage="RequiredFieldValidator" EnableClientScript="False" ValidationGroup="kontakt"></asp:RequiredFieldValidator>
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<asp:Button
ID="ButtonSend"
OnClick="ButtonSend_Click" runat="server" Text="Send" CausesValidation="true" ValidationGroup="kontakt" />
</td>
<td>&nbsp;</td>
</tr>
</table>
<asp:Label ID="LabelSvar" runat="server" Text=""></asp:Label>
</div>
<asp:SqlDataSource ID="SqlDataSourceKontakt" runat="server" ConnectionString='<%$ ConnectionStrings:DatabaseConnectionString1 %>' DeleteCommand="DELETE FROM [kontakt] WHERE [Id] = @Id" InsertCommand="INSERT INTO [kontakt] ([navn], [email], [telefon], [besked]) VALUES (@navn, @email, @telefon, @besked)" SelectCommand="SELECT * FROM [kontakt]" UpdateCommand="UPDATE [kontakt] SET [navn] = @navn, [email] = @email, [telefon] = @telefon, [besked] = @besked WHERE [Id] = @Id">
<DeleteParameters>
<asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="navn" Type="String"></asp:Parameter>
<asp:Parameter Name="email" Type="String"></asp:Parameter>
<asp:Parameter Name="telefon" Type="String"></asp:Parameter>
<asp:Parameter Name="besked" Type="String"></asp:Parameter>
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="navn" Type="String"></asp:Parameter>
<asp:Parameter Name="email" Type="String"></asp:Parameter>
<asp:Parameter Name="telefon" Type="String"></asp:Parameter>
<asp:Parameter Name="besked" Type="String"></asp:Parameter>
<asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
</UpdateParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
Raw
kontakt.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class kontakt : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ButtonSend_Click(object sender, EventArgs e)
{
if (IsValid)
{
SqlDataSourceKontakt.InsertParameters["navn"] = new Parameter("navn", System.Data.DbType.String, TextBoxNavn.Text);
SqlDataSourceKontakt.InsertParameters["email"] = new Parameter("email", System.Data.DbType.String, TextBoxEmail.Text);
SqlDataSourceKontakt.InsertParameters["telefon"] = new Parameter("telefon", System.Data.DbType.String, TextBoxTelefon.Text);
SqlDataSourceKontakt.InsertParameters["besked"] = new Parameter("besked", System.Data.DbType.String, TextBoxBesked.Text);
SqlDataSourceKontakt.Insert();
LabelSvar.Text = "Tak for din henvendelse. Vi vender tilbage snarest muligt.";
TextBoxNavn.Text = "";
TextBoxEmail.Text = "";
TextBoxTelefon.Text = "";
TextBoxBesked.Text = "";
//Response.Redirect("kontakt.aspx");
}
}
}
Raw
kontakt.sql
CREATE TABLE [dbo].[kontakt]
(
[Id] INT NOT NULL PRIMARY KEY IDENTITY,
[navn] NVARCHAR(50) NOT NULL,
[email] NVARCHAR(50) NOT NULL,
[telefon] NVARCHAR(20) NOT NULL,
[besked] NVARCHAR(MAX) NOT NULL
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment