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.Data;

namespace loginfunctietest
{
    public partial class login : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            lblErrorMsg.Visible = false;
        }

        protected void btnLogin_Click(object sender, EventArgs e)
        {
            using (SqlConnection sqlCon = new SqlConnection(@"Data Soure=(local)\sqle2012;inital Catalog=LoginDB;IntegratedSecurity=True"))
            {
                sqlCon.Open();
                string query = "SELECT COUNT(1) FROM gebruiker WHERE Naam=@Naam AND Wachtwoord=@Wachtwoord";
                SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
                sqlCmd.Parameters.AddWithValue("@Naam",txtNaam.Text.Trim());
                sqlCmd.Parameters.AddWithValue("@",txtWachtwoord.Text.Trim());
                int count = Convert.ToInt32(sqlCmd.ExecuteScalar());
                if(count ==1 )
                {
                    Session["Naam"] = txtNaam.Text.Trim();
                    Response.Redirect("dash.aspx");
                }
                else
                {
                    lblErrorMsg.Visible = true;
                }
            }
        }
    }
}