DataTable Select

Total Post:128

Points:898
 1502  View(s)
Ratings:
Rate this:

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?

  1. Post:378

    Points:2694
    Re: DataTable Select

    Hi Ashish, 


    try this:

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

      Modified On Apr-05-2018 05:47:00 AM

Answer