Created
December 3, 2014 11:49
-
-
Save s0ren/8f5d63257c1f86a8c404 to your computer and use it in GitHub Desktop.
Connection og alt sh** som klassevariabler...
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Linq; | |
using System.Web; | |
using System.Web.UI; | |
using System.Web.UI.WebControls; | |
using System.Data.SqlClient; | |
using System.Configuration; | |
using System.Data; | |
public partial class login : System.Web.UI.Page | |
{ | |
// Variablerne conn og cmd er flyttet ud i klassen, | |
// så de samme variabler er tilgængelige for alle metoder, og ikke skal gentages i hver af dem. | |
SqlConnection conn = new SqlConnection(); | |
SqlCommand cmd = new SqlCommand(); | |
// Contructor metode - udføres hver der oprettes en instans af denne klasse (når siden loader) | |
// Her kan vi sætte ConnectionString i conn og Connection i cmd | |
public login() | |
{ | |
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DatabaseConnectionString1"].ToString(); | |
cmd.Connection = conn; | |
conn.Open(); | |
} | |
// Destructor, udføres når klassen ikke bliver brugt længere... | |
~login() | |
{ | |
conn.Close(); | |
} | |
protected void Page_Load(object sender, EventArgs e) | |
{ | |
} | |
protected void ButtonLogin_Click(object sender, EventArgs e) | |
{ | |
cmd.CommandText = "SELECT * FROM login WHERE bruger = @login AND kode = @pass"; | |
cmd.Parameters.Add("@login", SqlDbType.VarChar).Value = TextBoxUsername.Text; | |
cmd.Parameters.Add("@pass", SqlDbType.VarChar).Value = TextBoxPW.Text; | |
SqlDataReader reader = cmd.ExecuteReader(); | |
if (reader.Read()) | |
{ | |
Session["bruger_id"] = reader["id"]; | |
Session["bruger_navn"] = reader["bruger"]; | |
//Response.Redirect(Session["returSide"].ToString()); | |
Label_respons.Text = "Du er nu logget ind som " + Session["bruger_navn"] + " med id: " + Session["bruger_id"]; | |
} | |
else | |
{ | |
Label_respons.Text = "Forkert brugernavn eller kodeord."; | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment