user identification

I’m using v1.1 framework and asp.net v1. Do I need to connect to the database to retrieve data first? How to do it?

How do i know that the user role in my database? What coding need to put?

The database is sql server 2000. There are three fields in the database, simply userid, password and role

help me coding this part

if User.IsInRole("Administrator") then
' Display......
ElseIf User.IsInRole("ModerateInfo") then
' Display.......
Else
' Display....
End If