DATATABLE SELECT

Ashish Pandey

Total Post:128

Points:898
Posted by  Ashish Pandey
 1137  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. Sumit Kesarwani

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!