public List <Ogretmen> OgretmenGetir()
{
Ogretmenler.Clear();
var connectionString = @"Server = DESKTOP-NCH3S9Q\SQLEXPRESS; Database = EgitimKayit; Integrated Security = true; ";
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand command = new SqlCommand("SELECT * FROM Ogretmenler", con);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Ogretmen ogretmen = new Ogretmen(reader.GetGuid(0).ToString(), reader.GetString(1));
Ogretmenler.Add(ogretmen);
}
con.Close();
return(Ogretmenler);
}
