Domain.AssetDatabaseController.ShowAssetInfo C# (CSharp) Method

        public List<string> ShowAssetInfo()
        {
            List<string> assetStringList = new List<string>();
            SqlConnection conn = new SqlConnection("Server=ealdb1.eal.local;Database=ejl49_db; User ID = ejl49_usr; Password = Baz1nga49");

            try
            {
                conn.Open();

                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "SELECT * from Asset";

                SqlDataReader rdr = cmd.ExecuteReader();

                while (rdr.Read())
                {
                    string tempAsset = "Id: " + rdr.GetInt32(0) + " Name: " + rdr.GetString(1);
                    assetStringList.Add(tempAsset);
                }

            }
            catch (SqlException es)
            {
                Console.WriteLine("UPS " + es.Message);
                Console.ReadLine();
            }
            finally
            {
                conn.Close();
            }
            return assetStringList;
        }