Veritabanı
Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace kullanici_giris
{
public partial class Form1 : Form
{
SqlConnection conn = new SqlConnection(“Data Source=.\\SQLEXPRESS; Initial Catalog=kullanici; Integrated Security=true;”);
Form2 frm2 = new Form2();
public Form1()
{
InitializeComponent();
}
private void temizle()
{
foreach (Control nesne in this.Controls)
{ if (nesne is TextBox)
{ TextBox textbox = (TextBox)nesne;
textbox.Clear();
}
}
}
private void button2_Click(object sender, EventArgs e)
{ string sorgu = “select * from bilgi where kullaniciAd='” + textBox1.Text + “‘ and sifre='” + textBox2.Text + “‘”;
SqlDataReader dr=frm2.verisorgula(sorgu);
if (dr.Read())
{ this.Hide();
Form3 frm = new Form3();
frm.Show();
}
else
{ MessageBox.Show(“Kullanıcı Adı veya Şifre yanlış…”);
temizle();
}
}
private void button1_Click(object sender, EventArgs e)
{
this.Hide();
Form2 frm = new Form2();
frm.Show();
}
}
}
form2.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace kullanici_giris
{
public partial class Form2 : Form
{
SqlConnection conn = new SqlConnection(“Data Source=.\\SQLEXPRESS; Initial Catalog=kullanici; Integrated Security=true;”);
public Form2()
{
InitializeComponent();
}
private void temizle()
{
foreach (Control nesne in this.Controls)
{
if (nesne is TextBox)
{
TextBox textbox = (TextBox)nesne;
textbox.Clear();
}
}
}
public SqlDataReader verisorgula(string sorgu)
{
if (conn.State == ConnectionState.Closed)
conn.Open();
SqlCommand sorgula = new SqlCommand(sorgu, conn);
SqlDataReader dr = sorgula.ExecuteReader();
return dr;
}
public void sorgucalistir(string sorgu)
{
if (conn.State == ConnectionState.Closed)
conn.Open();
SqlCommand cmd = new SqlCommand(sorgu, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
string sorgu = “select * from bilgi where kullaniciAd='” + textBox1.Text + “‘”;
SqlDataReader dr = verisorgula(sorgu);
if (dr.Read())
{
MessageBox.Show(“Aynı isimli kullanıcı var..”);
temizle();
}
else if (textBox2.Text == textBox3.Text)
{
dr.Close();
string eklemesorugusu = “insert into bilgi(kullaniciAd,sifre) values(‘” + textBox1.Text + “‘,'” + textBox2.Text + “‘)”;
sorgucalistir(eklemesorugusu);
MessageBox.Show(“Yeni kullanıcı Eklendi…”);
}
else
{
MessageBox.Show(“Şifreler aynı değil…”);
}
}
private void button1_Click(object sender, EventArgs e)
{
this.Hide();
Form1 frm = new Form1();
frm.Show();
}
private void Form2_FormClosing(object sender, FormClosingEventArgs e)
{
Application.Exit();
}
private void Form2_FormClosed(object sender, FormClosedEventArgs e)
{
}
}
}
Form3.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace kullanici_giris
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
private void Form3_FormClosing(object sender, FormClosingEventArgs e)
{
Application.Exit();
}
}
}
