title: convert dataset to datatable c#
body: <pre><code>ds.Tables.Add(dt);
  da = new SqlDataAdapter(
    @"select Time1, Time2, EndDate from Event 
      where Venue ='" + txtVenue.Text + "', 
      StartDate ='" + cbStartMonth.Text + "/" + 
      cbStartDay.Text + "/" + 
      DateTime.Today.Year + "'" ,conn);
  da.Fill(dt);
  </code></pre>
  
  <p>i'm sorry for the confusion, the code actually works but the problem is now how to view data coming from the data table</p>