title: Get a single value from dataSet in asp.net
body: <p>I am doing a query to get Title and RespondBY from the tbl_message table, I want to decrypt the Title before I do databinding to the repeater. How can I access the title value before doing databind.</p>
  
  <pre><code>string MysqlStatement = "SELECT Title, RespondBy  FROM tbl_message  WHERE tbl_message.MsgID = @MsgID";
  
  using (DataServer server = new DataServer())
  {
      MySqlParameter[] param = new MySqlParameter[1];
      param[0] = new MySqlParameter("@MsgID", MySqlDbType.Int32);
      param[0].Value = MessageID;
      command.Parameters.AddWithValue("@MsgID", MessageID);
      ds = server.ExecuteQuery(CommandType.Text, MysqlStatement, param);
  }
  rptList.DataSource = ds;
  rptList.DataBind();
  
  
    &lt;table style="width: 498px; color: #F5F5F5;"&gt;
          &lt;asp:Repeater ID="rptList" runat="server"&gt;
              &lt;HeaderTemplate&gt;
              &lt;/HeaderTemplate&gt;
              &lt;ItemTemplate&gt;
                  &lt;tr&gt;
                      &lt;td width="15%"&gt;
                          &lt;b&gt;Subject&lt;/b&gt;
                      &lt;/td&gt;
                      &lt;td width="60%"&gt;
                          &lt;asp:Label ID="lbl_Subj" runat="server" Text='&lt;%#Eval("Title")%&gt;' /&gt;
                      &lt;/td&gt;
                  &lt;/tr&gt;
  </code></pre>