0

I wanna edit this code so that it doesn't write article titles more than once. It should write an Article Title and under it should be all its comments. Any suggestions? (I am new to SQL so please be nice). Also I would like to specify when printing the Content that it's the Comment's content because the table Articles also has a Content in my database. Thank you.

string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\kunde\Desktop\Kódy\RedakcniSystemDB\Database.mdf; Integrated Security = True";
        //Console.WriteLine(connectionString);

        using (SqlConnection connection= new SqlConnection(connectionString))
        {
            pripojeni.Open();
            Console.WriteLine("Successfuly connected to database.");

            using (SqlCommand command = new SqlCommand("SELECT [Articles].[Title], [Comments].[Content] FROM [Articles] JOIN [Comments] ON [Comments].[ArticleId] = [Articles].[Id]", connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Console.WriteLine();
                        Console.WriteLine(reader["Title"]);
                        Console.WriteLine(reader["Content"]);
                    }
                }
            }
        }
        Console.ReadKey();
Mattias Kundert
  • 5
  • 2
  • Sounds like you need to keep track of which `Title` you're at, and output when it changes. Something like `if(title != (string)reader["Title"]) {title = reader["Title"]; Console.WriteLine(title);}` Side note: see [what's the issue with AttachDbFilename](https://stackoverflow.com/questions/11178720/whats-the-issue-with-attachdbfilename) – Charlieface Oct 17 '21 at 20:22

0 Answers0