check for user account if exits

Vignesh Kumar

10y1.1kLINQ

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
Accepted 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 Hiren9y ago
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 Mohapatra10y ago
You are using LINQ to fetch data from DataTable.So where is the problem now??
Vignesh Kumar10y ago
Updated my post. Could you please take a look.
Salman Beg10y ago
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.