DataTable Select
<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>
