Basic SQL Query From C#

BasicSqlCommand.cs

const string ConnectionString =
    "Data Source=DESKTOPPC;Initial Catalog=TSQL2012;Integrated Security=True";

using (var connection = new SqlConnection(ConnectionString))
{
    const string Query = "SELECT * FROM Sales.Orders WHERE custid = 71;";

    using (var adapter = new SqlDataAdapter(Query, connection))
    {
        var result = new DataTable();
        connection.Open();
        adapter.Fill(result);
    }

    connection.Open();
}