Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Windows.Forms;
- using System.Data.SqlClient;
- using System.Data;
- namespace LoginSys
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- }
- private void exitB_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- private void registerB_Click(object sender, EventArgs e)
- {
- Register reg = new Register();
- reg.Show();
- this.Hide();
- }
- private void loginB_Click(object sender, EventArgs e)
- {
- SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)MSSQLLocalDB;AttachDbFilename=C:UsersTeoDocumentsDatabasesLoginData.mdf;Integrated Security=True;Connect Timeout=30");
- string query = "select * from Table where username = " + username.Text.Trim() + " and password = " + password.Text.Trim() + ");";
- SqlDataAdapter sda = new SqlDataAdapter(query, conn);
- DataTable dt = new DataTable();
- sda.Fill(dt);
- if(dt.Rows.Count >= 1)
- {
- Register reg = new Register();
- reg.Show();
- this.Hide();
- }
- else
- {
- MessageBox.Show("Incorrect Password","Error");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement