public static bool DersEkle(Ders ders) { bool eklendi = false; MySqlConnection connection = null; try { string connectionString = "SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;"; connection = new MySqlConnection(connectionString); connection.Open(); string query = "INSERT INTO ders (Adi) VALUES('" + ders.DersAdi + "')"; //create command and assign the query and connection from the constructor MySqlCommand cmd = new MySqlCommand(query, connection); int sonucDeger = cmd.ExecuteNonQuery(); if (sonucDeger > 0) eklendi = true; } catch (Exception ex) { eklendi = false; } finally { connection.Close(); } return eklendi; }
public void Ders_Ekle() { Ders ders= new Ders(); ders.DersAdi = txtDersAdi.Text.Trim(); DersBL.DersEkle(ders); DersGetir(); }
public static List<Ders> DersGetir() { List<Ders> dersler = new List<Ders>(); MySqlConnection connection = null; try { string connectionString = "SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;"; connection = new MySqlConnection(connectionString); connection.Open(); string query = "SELECT * FROM Ders"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader reader = cmd.ExecuteReader(); // DataTable table = new DataTable(); // table.Load(reader); //for (int i = 0; i < table.Rows.Count; i++) // { // string adi = table.Rows[i]["Adi"].ToString(); // } while (reader.Read()) { Ders ders = new Ders(); ders.Id = (int)reader["Id"]; ders.DersAdi = reader["Adi"].ToString(); dersler.Add(ders); } } catch (Exception ex) { } finally { connection.Close(); } return dersler; }