using System;

using Microsoft.Data.SqlClient;

/*Can you identify the logic issues specifically in the try-catch-finally block?

Explain what could go wrong at runtime and suggest how to fix it.

​

*/

public class Program

{

    public static void Main()

    {

        SqlConnection conn = null;

    try

    {

        conn = new SqlConnection("Server=myserver;Database=mydb;User Id=admin;Password=secret;");

        conn.Open();

​

        Console.WriteLine("Connection opened.");

​

        SqlCommand cmd = new SqlCommand("SELECT * FROM Users", conn);

        SqlDataReader reader = cmd.ExecuteReader();

​

        while (reader.Read())

        {

            Console.WriteLine(reader["Name"].ToString());

        }

​

        Console.WriteLine("Data fetch complete.");

    }

    catch (Exception ex)

    {

        Console.WriteLine("Something went wrong.");

    }

    finally

    {

        conn.Close();

        Console.WriteLine("Connection closed.");

    }

    }

}