forum

Home / DeveloperSection / Forums / DataTable Select

Ask Question

DataTable Select

Anonymous User 2113 05-Sep-2014

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;

UserGridView.DataBind();

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?

asp.net asp.net 
Updated on 05-Sep-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Sumit Kesarwani

Sumit Kesarwani

05-Sep-2014
Hi Ashish, 

try this:

DataView view = new DataView();
view.Table = oDataTable;
view.RowFilter = "UserName = '" +
UserNameTextBox.Text + "'";
UserGridView.DataSource = view;
UserGridView.DataBind();

Liked By