How can I use Select method of a DataTable just to fetch UserNames starting with 'M'. Lets assume that UserNameTextBox has a string M
oDataTable.Select("UserName = '" + UserNameTextBox.Text + "'");
DataView oDataView = oDataTable.DefaultView;
oDataView.Sort = "UserName";
UserGridView.DataSource = oDataView;
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?