convert JSP code to c#

Question

i want to convert this code to c#..and if possible cud anyone explain me, what happens in the below code.....
............................................................................................................................................................................

ResultSet resultset;
            try {
                    Connection connection = DriverManager.getConnection("jdbc:odbc:rmcwhDSN");
                    Statement statement = connection.createStatement();
                    resultset=statement.executeQuery("select * from LoginTable");
                    String user="";
                    String pass="";
                    String role="";
                    String prefix="";
                    String temprole="ADMIN";
                    int flag = 0;                
                    if((request.getParameter("UserId") != null)  && (request.getParameter("Password") != null))
                   {
                        user=request.getParameter("UserId");
                        pass=request.getParameter("Password");
                        
                   }
                    while(resultset.next())
                   {
                        String UserId = resultset.getString("UserId");
                        String Password = resultset.getString("Password");
                      
                        role=resultset.getString("Role");
                        out.println("role"+role);
                        prefix = resultset.getString("Prefix");
                        //if role is "ADMIN" then by defalt asign prefix as "XXX"
                        if(( UserId.equals(user) ) && (Password.equals(pass)) && (role.equals(temprole)))
                       {
                            flag = 2;
                            session.putValue("UserId", user);
                             session.putValue("Role",role);
                            session.putValue("Prefix", prefix);
                           
                            
                        }
        
                    
                        
                        
                        
                          else if(( UserId.equals(user) ) && (Password.equals(pass)))
                       {
                            flag = 1;
                            session.putValue("UserId", user);
                           
                            session.putValue("Role",role);
                            //out.println("role"+role);
                             session.putValue("Prefix", prefix);
                            
                        }
                        
                             
    }