public Projekt GetProjekt(int proj_id) { Projekt p = new Projekt(); MySqlConnection conn = new MySqlConnection("server=localhost;uid=root;"); conn.Open(); conn.ChangeDatabase("projekte"); MySqlCommand comm = new MySqlCommand("select pj_id,pj_name from projekt where pj_id = " + proj_id, conn); MySqlDataReader Reader = comm.ExecuteReader(); Reader.Read(); p.Id = (int)Reader["pj_id"]; p.Name = Reader["pj_name"].ToString(); Reader.Close(); conn.Close(); return(p); }
public Projekt[] AlleProjekte() { List <Projekt> projekte = new List <Projekt>(); //comm.CommandText = "Select pj_id,pj_name from projekt"; //comm = conn.CreateCommand(); MySqlConnection conn = new MySqlConnection("server=localhost;uid=root;"); conn.Open(); conn.ChangeDatabase("projekte"); MySqlCommand comm = new MySqlCommand("Select pj_id,pj_name from projekt", conn); MySqlDataReader Reader = comm.ExecuteReader(); while (Reader.Read()) { Projekt p = new Projekt(); p.Id = (int)Reader["pj_id"]; p.Name = Reader["pj_name"].ToString(); projekte.Add(p); } Reader.Close(); conn.Close(); return(projekte.ToArray()); }