Today, I will teach you, how to design login form in WPF. Also, I will teach you, how it will work. In this example, I will take two text boxes, two Text Blocks and one button control from ToolBox. Now, create a database table with some following fields:
In this database table, I have three column, first column is automatic incremented by one.
CREATE TABLE [dbo].[users] (
[Id] INT NOT NULL IDENTITY,
[username] NVARCHAR (50) NULL,
[password] NVARCHAR (50) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
In this database table, I have three column, first column is automatic incremented by one.
<Window x:Class="WpfApplication5.additemwpflistview"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
Title="additemwpflistview" Height="300" Width="300">
<Grid>
<TextBlock HorizontalAlignment="Left" Margin="10,41,0,0" TextWrapping="Wrap" Text="UserName" VerticalAlignment="Top"/>
<TextBox Name="t1" HorizontalAlignment="Left" Height="23" Margin="94,41,0,0" TextWrapping="Wrap" Text="" VerticalAlignment="Top" Width="120"/>
<TextBlock HorizontalAlignment="Left" Margin="15,91,0,0" TextWrapping="Wrap" Text="Password" VerticalAlignment="Top"/>
<TextBox Name="t2" HorizontalAlignment="Left" Height="23" Margin="94,84,0,0" TextWrapping="Wrap" Text="" VerticalAlignment="Top" Width="120"/>
<Button Content="Login" HorizontalAlignment="Left" Margin="94,130,0,0" VerticalAlignment="Top" Width="75" Click="Button_Click"/>
</Grid>
</Window>
Note: Before doing all such things, must to add EDMX file in the project.
private void Button_Click(object sender, RoutedEventArgs e)
{
DatabaseEntities dbe = new DatabaseEntities();
if(t1.Text!= string.Empty || t2.Text!=string.Empty)
{
var users = dbe.users.FirstOrDefault(a => a.username.Equals(t1.Text));
if(users!=null)
{
if(users.password.Equals(t2.Text))
{
WPFListview l1 = new WPFListview();
l1.ShowDialog();
}
}
}
}
Code generates the following output: