check for user account if exits

Question

Hi I have a datatable like shown below User Password user1 pwd1 pwd1 pwd2 I have two textbox where the user will enter user name and password. How can I check if user name matches and password is entered wrongly. var userPassword = (from m in dt.AsEnumerable() where m.Field (User) == Usr && !(m.Field (Password) == sPwd) select m).Any();

Manas Mohapatra · Answer

Try like this: DataTable table = new DataTable(); // Presuming the DataTable has a column named Date. string expression = User = '+ textboxt1.Text+' and Password = '+ textboxt2.Text+' ; // Use the Select method to find all rows matching the filter. DataRow[] foundRows = table.Select(expression); if (foundRows.Rows.Count > 0) { return true ; } else { return false ; }

Ifour Hiren · Answer

var userPassword = (from m in dt.AsEnumerable() where m.Field (User) == Usr && !(m.Field (Password) == sPwd) select m).count(); if(userPassword>1) { } else { //Password Not Match }

Manas Mohapatra · Answer

You are using LINQ to fetch data from DataTable.So where is the problem now??

Salman · Answer

Hi. you can loop the datatable each row and check whether user name and password match with datatable each row and if it success then return true. foreach(DataRow dr in dt.Rows) { //check condition } Thanks.

Vignesh Kumar · Answer

Updated my post. Could you please take a look.