W019_LoginWithSQLServer

XAML에서의 디자인

<Window x:Class="W019_LoginWithSQLServer.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:local="clr-namespace:W019_LoginWithSQLServer"
        mc:Ignorable="d"
        Title="Login" Height="340" Width="300" Background="LightBlue">
    <Grid Margin="20" Background="White">
        <StackPanel Margin="20">
            <TextBlock Text="Login" FontSize="20" FontWeight="Bold"
                       HorizontalAlignment="Center" Margin="10"/>
            <Separator Background="Black"/>
            <TextBlock Text="UserName" FontSize="16" Margin="0.5"/>
            <TextBox x:Name="txtUserName" FontSize="16"/>
            <TextBlock Text="Password" FontSize="16"/>
            <PasswordBox x:Name="txtPassword" FontSize="16"/>
            <Button x:Name="btnLogin" Margin="0,20" Width="100"
                    Content="로그인"/>
        </StackPanel>
        
    </Grid>
</Window>

코드 

 

using System;
using System.Windows;
using System.Data.SqlClient;
using System.Data;

namespace W019_LoginWithSQLServer
{
    /// <summary>
    /// MainWindow.xaml에 대한 상호 작용 논리
    /// </summary>
    public partial class MainWindow : Window
    {
        string connStr = @"Data Source=(LocalDB)\MSSQLLocalDB;"
+ "AttachDbFilename=D:\팽귄\대학교\2학년 1학기\비주얼 프로그래밍\프로그래밍\VP2021\W019_LoginWithSQLServer\Login.mdf"
            + "Integrated Security=True";
        public MainWindow()
        {
            InitializeComponent();
        }

        private void btnLogin_Click(object sender, RoutedEventArgs e)
        {
            SqlConnection conn = new SqlConnection(connStr);
            if (conn.State == ConnectionState.Closed)
                conn.Open();

            string sql = string.Format("SELECT COUNT(*) FROM loginTable" +
                "WHERE UserName= '{0}' AND Password = '{1}'",
                txtUserName.Text, txtPassword.Password);
            SqlCommand comm = new SqlCommand(sql, conn);
            int count = Convert.ToInt32(comm.ExecuteScalar());
            if (count == 1)
            {
                MessageBox.Show("로그인 성공!");
            }
            else
                MessageBox.Show("로그인 실패!");

            conn.Close();
        }
    }
}

Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename="D:\팽귄\대학교\2학년 1학기\비주얼 프로그래밍\프로그래밍\VP2021\W019_LoginWithSQLServer\Login.mdf";Integrated Security=True
DB의 연결 문자열