User Authenication redirect by role

Hi all,
I have written the following code to authenticate a  user in the login form from a users table in a SqlExpress database table ("Users"). This table contains 3 fields, Name, Role and Password.
The code runs very well, but now I want to redirect the user based upon their role (Admin, Sales or CSR). I know I'll need to write an "if"  statement (and probably a string), but just can not quite seem to my thinking going on it.
Any help would be apprediated.
using System;
using System.Data;
using System.Configuration;
using System. ...