How to find a record in a dataset?

[Rom]

Hi,
How can I find a record in a dataset. I have 1 textbox name txtfind.
my sql statement should be like this.."select * from employees where emp_id= txtfind.text" then if found it should bind the fields to the corresponding textboxes on the form.

[scorpion53061]

You can use a datatable.selec t or prefably Use a dataview like in this
example provided by Cor or this link from Bill Ryan
http://www.knowdotnet.com/articles/a...rowfilter.html

See below this for example of datatable.selec t
------------------------

Hi Gene,

In addition to Jay B.

I also suggest to use the dataview.
\\\
dim dv as new dataview(mydata set.tables("myt able")
dv.rowfilter = "mysortitem < 100"
dv.sort = "mysortitem "
mycombobox.data source = dv
mycombobox.disp laymember = "xx"
///
This give you with a miniumum of code the maximum results in my idea.

Cor
-------------------------

Or datatable.Selec t example from BinSong....
---------------

Hi, Stu

Can you try this:
DataRow[] drReviewers = ReviewerDS.Tabl es["Menu"].Select("","Men uItem");
ReviewerMenu.Da taSource = drReviewers;
ReviewerMenu.Da taBind();
If not working, You might try the following because you are sorting only
instead of filtering and sorting:
DataView dvReviewer = ReviewerDS.Tabl es["Menu"].DefaultView
dvReviewer.Sort = "MenuItem"
ReviewerMenu.Da taSource = dvReviewer;
ReviewerMenu.Da taBind();
Hope this helps

Bin Song, MCP
"Rom" <Ro*@discussion s.microsoft.com > wrote in message
news:AE******** *************** ***********@mic rosoft.com:

Hi,
How can I find a record in a dataset. I have 1 textbox name txtfind.
my sql statement should be like this.."select * from employees where
emp_id= txtfind.text" then if found it should bind the fields to the
corresponding textboxes on the form.