title: How to select table for sql query without knowing the table name?
body: <p>I am using Visual Studio 2010. Web site with a SQL Server database. My database tables are named after the days of the week (ie. <code>mon</code>, <code>tue</code>, etc..) I want to use the current day (ie. <code>DateTime.Now.DayofWeek</code>) from a web form to determine the correct table to use, possibly through the <code>SqlDataSource</code> tool. </p>
  
  <p>For example:</p>
  
  <pre><code>'Finds current day
   Dim Day As String
      Day = CStr(DateTime.Now.DayOfWeek)
      lblSystemDateTime.Text = Day
      If lblSystemDateTime.Text = "1" Then
          lblDayName.Text = "mon"
      ElseIf lblSystemDateTime.Text = "2" Then
          lblDayName.Text = "tue"
  </code></pre>
  
  <p>If the current day is monday I want to be able to use code like I have above to select my database table named "mon". The sqldatasource requires the table name for it's wizard, therfore I have tried to use the custom sql statement builder to create my own workaround.</p>