How to Authenticate Users with the SQL Server database table using C# with Example?

Hi all,
Will anyone tell me how to Authenticate Users with the SQL Server database table using C#  with Example?
I've tried/used
Membership API controls for Login and Registering Users for authentication,
but i need/require to store Username/Password in a DatabaseTable(SQL SERVER table) in Register.aspx and then Match them against the DB table in Login.aspx page.Plz forward the two files.
I'm doing having great difficulty to accomplish that, Plz anyone provide me with the "Complete Example"  Easy to understand and simple code 
to authenticate against a DB table  
Thanks
 
...