code for login table

Question

i have a login table which has 

UserID    UserName           Password                                OrgID    RoleID        Count     Lastlogin

123           lab1           svkLRj9nYEgZo7gWDJD5IQ==        5            1                   0         NULL

 

 

and so on i have designed a form which has username and pasword i want to write a code in c# with sql query that if you pur credential from login table then new page to be displayed

 

 

 

thanks