Display database value based on which radio button is selected
<p>I am suppose to display the database values in a gridview based on which radio button is selected. I'm currently using a RadioButtonList and I'm supposed to display certain transactions based on the transaction date they select in the radio button. For example, if they select View past 1 Month transaction, my gridview is suppose to show only the past one month transaction. I'm currently using C#. </p>

<p>The date is retrieved base on system date and are recorded when there are transactions made. May I know how to link the radio transaction with the database using gridview ?</p>

<p><img src="http://i.stack.imgur.com/YmHT1.png" alt="enter image description here">
<img src="http://i.stack.imgur.com/hOvTs.png" alt="enter image description here"></p>

<p>This is my coding for the gridview.</p>

<pre><code>     myConnection.ConnectionString = strConnectionString;
    SqlCommand cmd = new SqlCommand("SELECT thDate, thType, thAmountIn, thAmountOut from [Transaction] ORDER BY thDate, thType, thAmountIn, thAmountOut DESC", myConnection);
    myConnection.Open();
    SqlDataReader reader1 = cmd.ExecuteReader();
    GridView1.DataSource = reader1;
    GridView1.DataBind();
</code></pre>
