using System;

using System.Data.SqlClient;

public class Program

{

    public static void Main()

    {

        string databaseInfo = "connection info";

        string result;

        SqlConnection connection = new SqlConnection(databaseInfo);

        try

        {

            connection.Open();

            string SqlCommand = "do this, I only need one result";

            SqlCommand command = new SqlCommand();

            command.Connection = connection;

            command.CommandText = SqlCommand;

            result = (string)command.ExecuteScalar();

        }

        finally

        {

            if (connection != null)

                connection.Close();

        }

    }

}