Mirroring a java functionality

See more:

C#

ASP.NET

Java

Hey guys I need your help,
So the code below is simple, it query's a database table(User) for everything in it and puts that data in a result set. I wanted only the firstname from the table, but I commented it out for now since it works.

public static void main(String[] args) throws Exception
{
    // TODO Auto-generated method stub

    Class.forName("com.mysql.jdbc.Driver");

    Connection con = DriverManager.getConnection("jdbc:mysql://rideon.db.12096379.hostedresource.com:3306/rideon","rideon","Rideon12#");

    PreparedStatement statement = con.prepareStatement("select * from User");

    //ResultSet result = statement.executeQuery();

    ResultSet result  = statement.executeQuery();

    closeResultSet(result);

    while(result.next())
    {

    //System.out.println(result.getS­tring(1) + " " + result.getString(2));
        //System.out.println(result.getString("FirstName"));


    }

 }

now this second code checks if the passed result set is not empty. If its not, then a second statement object is created and the first statement object that populated the result set is passed to it and closed

 public static void closeResultSet(ResultSet rs)
 {
      try {
            if (rs != null)
            {
               Statement st = rs.getStatement();

               System.out.println("This is what is in the statement:"+ st);

                   st.close();
            }
    }catch (Exception e)
    {
        System.out.println("spider monkey");
    }
}

if I go and print out what is in the second statement, this is what I get

Printout: This is what is in the statement:com.mysql.jdbc.JDBC4PreparedStatement@1a4788f3: select * from User


This is what I passed to Prepared statement originally.

So my question is, is there a way I can mirror The second function(closeResultSet(ResultSet rs))in C#.


Thanks for your help.