public static void GetAllInspections() { sqlconn.Open(); Engine.inspectionList.Clear(); string sql = @" SELECT [Id] ,[RegistrationNumber] ,[PerformedAt] ,[IsApproved] FROM [FIRSTTURNINADO].[dbo].[Inspection] "; SqlCommand command = new SqlCommand(sql, sqlconn); //Skicka SQL kommando till servern //Servern svarar nu i dataReader SqlDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { int id = int.Parse(dataReader["Id"].ToString()); string registrationNumber = dataReader["RegistrationNumber"].ToString(); DateTime date = DateTime.Parse(dataReader["PerformedAt"].ToString()); bool isApproved = bool.Parse(dataReader["IsApproved"].ToString()); Inspection inspectionPlaceHolder = new Inspection(id, registrationNumber, date, isApproved); // string completed = dataReader["Completed"].ToString(); Engine.inspectionList.Add(inspectionPlaceHolder); } //Console.WriteLine("Hello Database Yes?"); sqlconn.Close(); }