private void button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\ABRA\Desktop\CS\3.sınıf\veritabanı yönetim sistemleri\veritabani\veritabaniOdev.mdf;Integrated Security=True;Connect Timeout=30");
conn.Open();
string sql = null;
sql = @"select dbo.func_HastaLogin(@username,@password)"; // fonksiyon login
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@username", hasta_txtBox.Text);
cmd.Parameters.AddWithValue("@password", hastapassword_txtBox.Text);
int result = (int)cmd.ExecuteScalar();
if (result == 1)
{
HastaEkrani he = new HastaEkrani();
he.Show();
this.Hide();
}
else
{
MessageBox.Show("Lütfen bilgileri tekrar kontrol ediniz!");
}
}
catch (Exception ex)
{
MessageBox.Show("Error! Kod:{0}", ex.Message);;
}
}
private void button6_Click(object sender, EventArgs e)
{
HastaEkrani hs = new HastaEkrani();
hs.Show();
this.Hide();
}
