using System;

using System.Data.SqlClient;

​

class Program

{

    static void Main(string[] args)

    {

        string connectionString = "Server=your_server_name;Database=your_database_name;Trusted_Connection=True;";

​

        string query = "SELECT StudentID, Name, Age FROM Students";

​

        using (SqlConnection connection = new SqlConnection(connectionString))

        {

            try

            {

                connection.Open();

​

                using (SqlCommand command = new SqlCommand(query, connection))

                {

                    using (SqlDataReader reader = command.ExecuteReader())

                    {

                        if (reader.HasRows)

                        {

                            while (reader.Read())

                            {

                                int studentId = reader.GetInt32(0); 

                                string name = reader.GetString(1); 

                                int age = reader.GetInt32(2); 

​

                                Console.WriteLine($"ID: {studentId}, Name: {name}, Age: {age}");

                            }

                        }

                        else

                        {

                            Console.WriteLine("No rows found.");

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                Console.WriteLine($"An error occurred: {ex.Message}");

            }

        }

    }

}

​