1
hello adam
try this
OleDbConnection oCon = new OleDbConnection("Put your Connection string");
oCon.Open();
object obj;
string str = "Select count(*) from tablename where Login='" + UserId + "' ams password ='" + password + "' ";
OleDbCommand cmd = new OleDbCommand(str, oCon);
obj = cmd.ExecuteScalar();
if ((int)obj!= 0)
{
//Login successfull
}
else
{
// Unsuccessfull
}
thanks
please mark as answer if it helps
Accepted