title: Using Variables in a fill query in a TableAdapter
body: <p>I’m using C# and Winforms. I’m trying to make a report that gives a list of people that need to renew their memberships if they expire within a user supplied date range. I've got a connection to an Access file, and I'm trying to set up a fill query for a TableAdapter, and I can’t figure out how to put a variable in my "WHERE" clause. The below SQL works to do what I need but obviously I don’t want to hard code the dates. I would like to substitute the dates with the variables “fromDate” and “toDate”. How can I do this? Thanks.</p>
  
  <pre><code>SELECT   [Last Name], [First Name], [Renewal Date]
  FROM     Members
  WHERE    ([Renewal Date] &gt;= #1/1/2000#) AND ([Renewal Date] &lt;= #1/1/2012#)
  ORDER BY [Renewal Date]
  </code></pre>