title: C# Dataset - How to show same record with different dates
body: <p>I have a table that stores information about some events which are shown on the website. These events repeat every week,so instead of entering the same event for every week I wanted to have the option that the user will just select the checkbox (repeat every week), and then somehow read if the record has this checked show the record with different dates(add seven days). Another problem is that there might be more than two events that will repeat every week. I thought I should handle this on runtime when the page loads or should I handle this when the data is entered? Can someone give me  a direction? When the page loads I'm simply filling the dataset as follows and then just binding the gird to the dataset:</p>
  
  <pre><code>        DataSet eventsDS = new DataSet();
  
          SqlConnection conn = new SqlConnection();
          conn.ConnectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
  
          SqlCommand command = new SqlCommand("SELECT * FROM [tbl_events]order by [date]", conn);
  
          SqlDataAdapter daEvents = new SqlDataAdapter(command);
          daEvents.Fill(eventsDS);
  </code></pre>