How to compare single value of textbox with all the value of dataset

[rakesh salwe]

hello sir,

my name is rakesh salwe. i wanna compare the value which is entered by user in textbox with the all the values present in the dataset one by one for login purpose. thank you

[Plater]

DataTable objects have a Select() function which you can use to grab a DataRow[] (array) of any rows that match the select statement.

So if you said:

 
DataRow[] results=myDataTable.Select("Username='"+tbUsername.Text+"'");
// results now contains any rows from the DataTable 
// that have the contents of the textbox as the value for the Username column
 

[Subin Ninan]

This can be done using foreach loop.