DataTable Select

Anonymous User 2516 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?

Ask by Anonymous User

Updated 05 Sep 2014

1 Answers

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();

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

DataTable Select

Can you answer this question?

1 Answers