title: DataTable Select
body: <p>How can I use Select method of a DataTable just to fetch UserNames starting with 'M'. Lets assume that UserNameTextBox has a string <strong>M</strong></p>
  
  <pre><code>oDataTable.Select("UserName = '" + UserNameTextBox.Text + "'");
  DataView oDataView = oDataTable.DefaultView;
  oDataView.Sort = "UserName";
  UserGridView.DataSource = oDataView;
  UserGridView.DataBind();
  </code></pre>
  
  <p>and when I typed full name into textbox, which I am sure DataTable contains, it list everything not just what I typed. Can someone help me please?</p>