ARTICLE

Login and registration process in WPF application

Posted by Purushottam Rathore in Articles | WPF using VB.NET on September 20, 2010

Tags: Login and registration in WPF application, login in wpf, visual studio 2010, wpf, xaml

In this article, I am creating a simple application for login and registration using WPF in visual studio 2010.

Tweet
2375
12

Reader Level: Beginner

Introduction:

In this article I am creating a simple application for login and registration using WPF in visual studio 2010. In this application I am creating two window forms one is for Registration and another is for login. First of all user will register after then he/she can login.

Now I am going to discuss in brief about this application.

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

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

Figure 1:

Step 2: Enter your project name and click on OK button.

Step 3: You will get the MainWindow.xaml window form, if you want to change then rename it and also change the StartupUri property of application into App.xaml like as follows:

App.xaml:

<Application x:Class="Login_WPF.App"

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

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

StartupUri="Registration.xaml">

<Application.Resources></Application.Resources>

</Application>

Step 4: Now design your Registration page as figure 2 or copy and page following inline code.

Registration.xaml:

<Window x:Class="Login_WPF.Registration"

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

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

Title="Registration" Height="387" Width="528" Background="Black">

<Button.Template>

</TextBlock>

</ControlTemplate>

</Button.Template>

<Button.Style>

<Style.Triggers>

</Trigger>

</Style.Triggers>

</Style>

</Button.Style>

</Button>

<Grid.RowDefinitions>

</Grid.RowDefinitions>

</Grid>

</Window>

Figure 2: Registration form

Registration.xaml.cs:

Imports System.Collections.Generic
Imports System.Linq
Imports System.Text
Imports System.Windows
Imports System.Windows.Controls
Imports System.Windows.Data
Imports System.Windows.Documents
Imports System.Windows.Input
Imports System.Windows.Media
Imports System.Windows.Media.Imaging
Imports System.Windows.Shapes
Imports System.Data
Imports System.Data.SqlClient
Imports System.Text.RegularExpressions

Namespace Login_WPF
    ''' <summary>
    ''' Interaction logic for Registration.xaml
    ''' </summary>
    Partial Public Class Registration
        Inherits Window
        Public Sub New()
            InitializeComponent()
        End Sub

        Private Sub Login_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
            Dim login As New Login()
            login.Show()
            Close()
        End Sub

        Private Sub button2_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
            Reset()
        End Sub

        Public Sub Reset()
            textBoxFirstName.Text = ""
            textBoxLastName.Text = ""
            textBoxEmail.Text = ""
            textBoxAddress.Text = ""
            passwordBox1.Password = ""
            passwordBoxConfirm.Password = ""
        End Sub
       Private Sub button3_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
            Close()
        End Sub

        Private Sub Submit_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
            If textBoxEmail.Text.Length = 0 Then
                errormessage.Text = "Enter an email."
                textBoxEmail.Focus()
            ElseIf Not Regex.IsMatch(textBoxEmail.Text, "^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$") Then
                errormessage.Text = "Enter a valid email."
                textBoxEmail.[Select](0, textBoxEmail.Text.Length)
                textBoxEmail.Focus()
            Else
                Dim firstname As String = textBoxFirstName.Text
                Dim lastname As String = textBoxLastName.Text
                Dim email As String = textBoxEmail.Text
                Dim password As String = passwordBox1.Password
                If passwordBox1.Password.Length = 0 Then
                    errormessage.Text = "Enter password."
                    passwordBox1.Focus()
                ElseIf passwordBoxConfirm.Password.Length = 0 Then
                    errormessage.Text = "Enter Confirm password."
                    passwordBoxConfirm.Focus()
                ElseIf passwordBox1.Password <> passwordBoxConfirm.Password Then
                    errormessage.Text = "Confirm password must be same as password."
                    passwordBoxConfirm.Focus()
                Else
                    errormessage.Text = ""
                    Dim address As String = textBoxAddress.Text
                    Dim con As New SqlConnection("Data Source=TESTPURU;Initial Catalog=Data;User ID=sa;Password=wintellect")
                    con.Open()
                    Dim cmd As New SqlCommand("Insert into Registration (FirstName,LastName,Email,Password,Address) values('" & firstname & "','" & lastname & "','" & email & "','" & password & "','" & address & "')", con)
                    cmd.CommandType = CommandType.Text
                    cmd.ExecuteNonQuery()
                    con.Close()
                    errormessage.Text = "You have Registered successfully."
                    Reset()
                End If
            End If
        End Sub
    End Class
End Namespace

Now I am taking another form for login as follows:

Login.xaml:

<Window x:Class="Login_WPF.Login"

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

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

Title="Login" Height="350" Width="525">

<Grid>

Note: Please login here to view the features of this site. If you are new on this site then <LineBreak />

please click on

<Hyperlink Click="buttonRegister_Click" FontSize="14" FontStyle="Normal">Register</Hyperlink>

</TextBlock>

button

</TextBlock>

</Grid>

</Window>

Figure 3: Login form.

Login.xaml.cs:

Imports System.Collections.Generic
Imports System.Linq
Imports System.Text
Imports System.Windows
Imports System.Windows.Controls
Imports System.Windows.Data
Imports System.Windows.Documents
Imports System.Windows.Input
Imports System.Windows.Media
Imports System.Windows.Media.Imaging
Imports System.Windows.Navigation
Imports System.Windows.Shapes
Imports System.Data
Imports System.Data.SqlClient
Imports System.Text.RegularExpressions

Namespace Login_WPF
    ''' <summary>
    ''' Interaction logic for MainWindow.xaml
    ''' </summary>

    Partial Public Class Login
        Inherits Window
        Public Sub New()
            InitializeComponent()
        End Sub
        Private registration As New Registration()
        Private welcome As New Welcome()

        Private Sub button1_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
            If textBoxEmail.Text.Length = 0 Then
                errormessage.Text = "Enter an email."
                textBoxEmail.Focus()
            ElseIf Not Regex.IsMatch(textBoxEmail.Text, "^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a
zA-Z\.]*[a-zA-Z]$") Then
                errormessage.Text = "Enter a valid email."
                textBoxEmail.[Select](0, textBoxEmail.Text.Length)
                textBoxEmail.Focus()
            Else
                Dim email As String = textBoxEmail.Text
                Dim password As String = passwordBox1.Password
                Dim con As New SqlConnection("Data Source=TESTPURU;Initial Catalog=Data;User ID=sa;Password=wintellect")
                con.Open()
                Dim cmd As New SqlCommand("Select * from Registration where Email='" & email & "' and password='" & password &
"'", con)
                cmd.CommandType = CommandType.Text
                Dim adapter As New SqlDataAdapter()
                adapter.SelectCommand = cmd
                Dim dataSet As New DataSet()
                adapter.Fill(dataSet)
                If dataSet.Tables(0).Rows.Count > 0 Then
                    Dim username As String = dataSet.Tables(0).Rows(0)("FirstName").ToString() & " " & dataSet.Tables(0).Rows(0
("LastName").ToString()
                    welcome.TextBlockName.Text = username
                    'Sending value from one form to another form.
                    welcome.Show()
                    Close()
                Else
                    errormessage.Text = "Sorry! Please enter existing emailid/password."
                End If
                con.Close()
            End If
        End Sub

        Private Sub buttonRegister_Click(ByVal sender As Object, ByVal e As RoutedEventArgs)
            registration.Show()
            Close()
        End Sub

End Class
End Namespace

Welcome.xaml:

<Window x:Class="Login_WPF.Welcome"

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

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

Title="Welcome" Height="250" Width="400">

<Grid>

</Grid>

</Window>

At last if user login successfully then welcome message will display on another form as shown below:

Figure 4:

post comment

It doesn't work because I need the SQL setup. I know how to create a database but sure what all this represents. ("Data Source=TESTPURU;Initial Catalog=Data;User ID=sa;Password=wintellect");

Posted by L Van on Oct 10, 2011

For best practice, shouldn't you keep the SQL separate from this and probably in a stored procedure? I'm very new to this and am trying to learn the correct way.

Posted by L Van on Sep 20, 2011

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) what i should do???

Posted by mada sattar on Jun 30, 2011

Please verify the value of firstname should not be null.

Posted by Purushottam Rathore on May 30, 2011

welcome.TextBlockName.Text = username;//Sending value from one form to another form. welcome.Show(); Close(); ********************************************** though I hav copied all the codes from your ,which u had described but I am facing aNull Referance in the above line,Plz verify the problem and help me as I a beginner here thankinh You Sir .Plzzz

Posted by ashish tiwari on May 30, 2011

View All

TOP LEADERS