title: Retrieving data from Oracle
body: <p>I want retrieve data from oracle database, below is my code,
  My sql query has 4 results how can i retrieve 4 result in my label.  </p>
  
  <h2>Code</h2>
  
  <pre><code>OracleConnection con = new OracleConnection(
  "Data Source=10.127.240.216/ipcldb;User ID=ipcltos;Password=ipcltos;Unicode=True");   
  con.Open();
  OracleCommand cmd = new OracleCommand(
  "select Initcap(ZZFNAME) ZZFNAME 
  from sap_empmst where substr(GBDAT,1,6) = substr(sysdate,1,6) 
  and stat2 =3 and werks in('RIGC','IPGC') and plans&lt;99999999 order by persk", con);      
  OracleDataReader dr = cmd.ExecuteReader();
  dr.Read();     
  // int i;
  //   for (i = 0; i &lt; 10; i++)
  Label1.Text = dr.GetString(0);
  con.Dispose();
  </code></pre>
  
  <p>thanks in advance.</p>