java code to c#...

Question

i want the given java code in c#...cud anyone help me with this.....

ResultSet resultset, resultset1;
            String localityid,villageid;
            try{
            Connection connection= DriverManager.getConnection("jdbc:odbc:rmcwhDSN");
            Statement statement= connection.createStatement();
            String familyid = request.getParameter("familyid");
            String tempSQL = "select * from HOUSEHOLDMEMBERS where FamilyId='"+familyid+"'";
            //out.println(tempSQL);
            resultset=statement.executeQuery(tempSQL);
            String tempMemberid="";
            String tempNum="";
            while(resultset.next())
            {
            tempMemberid = resultset.getString("MemberId");
            }
            //out.println(tempMemberid);
            int count1 = tempMemberid.length();
           // out.println(count1);
            
            //if(countl >2 ) {
                String memnum = tempMemberid.substring(count1-2);
                int memno = (new Integer(memnum)).intValue();
                //out.println ("Last member sq. number " + memno);                           
                memno++;
                String seqNo = Integer.toString(memno);
               // out.println ("Last member sq. number " + seqNo);                           
                if(memno < 10) {
                    tempMemberid = familyid.concat("0").concat(seqNo);
                }else{
                    tempMemberid = familyid.concat(seqNo);
                }
           // }    
            //tempMemberid = familyid.concat(count2);