Here is the sample code and slide deck from my session at ASP.NET Connections.
ASC302: Implementing Role-based Security with ASP.NET and SQL Server 2000
Security in Web applications is paramount, and a current hot topic. In this session, you will learn how to implement a complete role-based security model for a Web application. You will learn how security plays a role in the ASP.NET Framework, how to set up user roles in a SQL Server database, and how to use them effectively. Through this presentation, you will learn how to quickly and effectively implement a role-based security model using ASP.NET and SQL Server 2000.