public static bool OgrenciDersEkle(OgrenciDersleri secilenDers) { 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 ogrencidersleri (Ogrenci,Ders) VALUES('" + secilenDers.Ogrenci.Id + "','" + secilenDers.Ders.Id + "')"; //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 static List<OgrenciDersleri> OgrenciDersGetir(Ogrenci ogrenci) { List<OgrenciDersleri> ogrenciDersleri = new List<OgrenciDersleri>(); MySqlConnection connection=null; try { string connectionString="SERVER=localhost;DATABASE=OgrenciYonetimSistemi; UID=root;PASSWORD=hy050491;"; connection = new MySqlConnection(connectionString); connection.Open(); string query = "SELECT * FROM OgrenciDersleri"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader reader= cmd.ExecuteReader(); while (reader.Read()) { OgrenciDersleri ogreciDers = new OgrenciDersleri(); ogreciDers.Id = Convert.ToInt32(reader["Id"]); ogreciDers.Ogrenci = new Ogrenci(); ogreciDers.Ogrenci.Id = Convert.ToInt32(reader["Ogrenci"]); ogreciDers.Ders = new Ders(); ogreciDers.Ders.Id = Convert.ToInt32(reader["Ders"]); string studentQuery = "SELECT * FROM Ogrenci WHERE Id = '" + ogreciDers.Ogrenci.Id + "'"; MySqlCommand cmdStudent = new MySqlCommand(query, connection); MySqlDataReader readerStudent = cmd.ExecuteReader(); while (readerStudent.Read()) { ogreciDers.Ogrenci.Adi = readerStudent["Adi"].ToString(); ogreciDers.Ogrenci.Soyadi = readerStudent["Soyadi"].ToString(); } ogrenciDersleri.Add(ogreciDers); } connection.Close(); DataTable table = new DataTable(); table.Load(reader); for (int i = 0; i < table.Rows.Count; i++) { string adi = table.Rows[i]["Id"].ToString(); } //DersBilgileriDoldur(ogrenciDersleri); } catch (Exception ex) { } finally { connection.Close(); } return ogrenciDersleri; }
private void button1_Click(object sender, EventArgs e) { Ders secilenDers = dgvDersListesi.SelectedRows[0].DataBoundItem as Ders; if (secilenDers != null) { OgrenciDersleri yeniDers = new OgrenciDersleri(); yeniDers.Ogrenci = _ogrenci; yeniDers.Ders = secilenDers; OgrenciBL.OgrenciDersEkle(yeniDers); } }