title: C# forms Textbox value against database value, sql command or datadapter dataset
body: <p>Basically what I'm trying to achieve is the following:-</p>
  
  <p>I have a text box field with a value, I want to check this value against the value in the SQL Server database if there's a match then do a particular task.</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>SELECT        userID, username , password
  FROM           Users
  WHERE        (username = textboxUsername.text) AND (password = textboxPassword.text
  </code></pre>
  
  <p>But it doesnt seem to work for me, I think I'm almost doing it correctly?</p>
  
  <p>Also would I be better off using a data set or just a bog stand sql command as there will be other queries to be carried out?</p>
  
  <p>Many thanks</p>