using System;
using System.Collections.Generic;
using System.Text;

using Microsoft.Data.SAPClient;

namespace SapAdoSelect
{
    class Program
    {
        static void Main(string[] args)
        {
        /// <summary>
        /// select top 1 * from sflight inner join spfli on sflight.connid = spfli.connid where spfli.connid = @connid
        /// </summary>

        string connstr = "TYPE=A; ASHOST=YourSapHost; SYSNR=00; CLIENT=800; LANG=EN; USER=YourUserName; PASSWD=YourPassword;";

           using (SAPConnection conn = new SAPConnection(connstr))
            {
                conn.Open();
                using (SAPCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select top 1 * from sflight inner join spfli on sflight.connid = spfli.connid where spfli.connid = @connid";
                    cmd.Parameters.Add(new SAPParameter("@connid", 17));                    
                    using (SAPDataReader dr = cmd.ExecuteReader())
                    {
                        do
                        {
                            int rows = 0;
                            while (dr.Read())
                            {
                                rows++;
                                StringBuilder b = new StringBuilder();
                                for (int i = 0; i < dr.FieldCount; i++)
                                {
                                    b.Append(dr[i].ToString()+" ");
                                }
                                Console.WriteLine("row {0}: {1} ", rows, b.ToString());
                            }
                            Console.WriteLine("Number of rows:{0}", rows);

                        } while (dr.NextResult());
                    }
                }
            }
        }
    }
}