ASP.NET Tutorials with SQL Training Course

Tuesday, 12 May 2015

Creating simple login and registration form in WPF

Download the source code of the project from here : Login.ZIP

Introduction :

In this article we are going to create a WPF application for simple login and registration process.

Step 1.

Open Visual Studio 2010 -> File -> New -> Project.

New project template will display and select WPF Application like as follows:

Give your project a meaningful name, I am naming my project as “CustomerRelationManagement”

Step 2.

Here you will get MainWindow.xaml window, you can rename it to Login.xaml

Step 3.

Code in app.xaml

<?xml version="1.0" encoding="utf-8" ?>

</configSections>

<add name="conn"

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

</connectionStrings>

</configuration>

Step 4.

<Window x:Class="CustomerRelationManagement.Login"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

Title="Login" Height="400" Width="500" WindowStartupLocation="CenterScreen">

</Grid>

</Window>

Step 5.

using System;

using System.Collections.Generic;

using System.Text;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Imaging;

using System.Windows.Shapes;

using System.Configuration;

using System.Data.SqlClient;

using System.Data;

namespace CustomerRelationManagement

{

/// <summary>

/// Interaction logic for Login.xaml

/// </summary>

public partial class Login : Window

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());

public Login()

{

InitializeComponent();

}

private void button2_Click(object sender, RoutedEventArgs e)

{

reg.Show();

this.Hide();

}

private void button1_Click(object sender, RoutedEventArgs e)

{

SqlDataAdapter da = new SqlDataAdapter("select * from employee where email = '" + txtemail.Text.Trim() + "' and password = '" + txtpassword.Password.Trim() + "'", con);

DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

Welcome wel = new Welcome(dt.Rows[0]["name"].ToString());

wel.Show();

this.Hide();

}

else

{

MessageBox.Show("Invalid Details.");

}

Step 6.

<Window x:Class="CustomerRelationManagement.Register"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

Title="Register" Height="500" Width="500" WindowStartupLocation="CenterScreen">

</Grid>

</Window>

Step 7.

using System;

using System.Collections.Generic;

using System.Text;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Imaging;

using System.Windows.Shapes;

using System.Configuration;

using System.Data.SqlClient;

namespace CustomerRelationManagement

{

/// <summary>

/// Interaction logic for Register.xaml

/// </summary>

public partial class Register : Window

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());

public Register()

{

InitializeComponent();

}

private void button2_Click(object sender, RoutedEventArgs e)

{

log.Show();

this.Hide();

}

private void button1_Click(object sender, RoutedEventArgs e)

{

if (txtemail.Text.Trim() != "" && txtname.Text.Trim() != "" && txtpassword.Password.Trim() != "")

{

try

{

if (con.State == System.Data.ConnectionState.Closed)

{

con.Open();

}

SqlCommand cmd = new SqlCommand("proc_register", con);

cmd.CommandType = System.Data.CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@email", txtemail.Text.Trim());

cmd.Parameters.AddWithValue("@name", txtname.Text.Trim());

cmd.Parameters.AddWithValue("@password", txtpassword.Password.Trim());

int i = cmd.ExecuteNonQuery();

if (i > 0)

{

MessageBox.Show("Registration Successfull.");

log.Show();

this.Hide();

}

catch (Exception ex)

{

throw ex;

}

finally

{

con.Close();

}

else

{

MessageBox.Show("Please fill all details");

}

Step 8.

Welcome.xaml

<Window x:Class="CustomerRelationManagement.Welcome"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

Title="Welcome" Height="300" Width="500" WindowStartupLocation="CenterScreen" Loaded="Window_Loaded">

<Grid>

</Grid>

</Window>

Step 9.

Welcome.xaml.cs

using System;

using System.Collections.Generic;

using System.Text;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Imaging;

using System.Windows.Shapes;

namespace CustomerRelationManagement

{

/// <summary>

/// Interaction logic for Welcome.xaml

/// </summary>

public partial class Welcome : Window

{

static string nm;

public Welcome(string name)

{

InitializeComponent();

nm = name;

}

private void Window_Loaded(object sender, RoutedEventArgs e)

{

label1.Content = "Welcome " + nm;

}

Step 10.

App.config

<?xml version="1.0" encoding="utf-8" ?>

</configSections>

<add name="conn"

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

</connectionStrings>

</configuration>

Step 11.

Add service base database model to your project, in my case I have named it as Database1.mdf

And create a table named employee as

And a stored procedure named proc_register as

ALTER PROCEDURE dbo.proc_register

@email nvarchar(max), @name nvarchar(max), @password nvarchar(max)

begin

if not exists(select * from employee where email <> @email)

begin

insert into employee(name, email, password)

values(@name, @email, @password)

end

to learn more about sql click here...

download the source code for the file from here : Login.ZIP

Pages

Tuesday, 12 May 2015

Creating simple login and registration form in WPF