Authenticate User ID and Password from DB in ASP.NET with ADO.NET

Question

Hi Guys,
How I can authenticate an user with login id and password in ASP.NET with C# via ADO.NET.
Kindly, advise me in this regard.
Thanks

Itz.Irshad