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(); }