title: Select sql how to get value DataReader
body: <p>I want to retrieve value /miejsca/, but I don't how it works. For example please show me how selecting value define as variable or how to show it in textbox.</p>
  
  <p>At this point I recieve "System.Data.SqlClient.SqlDataReader" in textbox.</p>
  
  <pre><code>        SqlDataReader reader;
          cn.Open();
          cmd.CommandText = ("SELECT miejsca FROM oferty WHERE oferty.idoferty = @rezerw");
          cmd.Parameters.AddWithValue("@rezerw", rezerw);
          cmd.CommandType = CommandType.Text;
          cmd.Connection = cn;
          reader = cmd.ExecuteReader().Read
          string rs = Convert.ToString(reader);
          TextBox1.Text = rs;//at this point i recieve "System.Data.SqlClient.SqlDataReader" in textbox
          cn.Close();
  </code></pre>